473,786 Members | 2,462 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Win XP Missing MySQL ODBC 3.51

Hello
Windows XP sp2, Installed MyODBC 3.51 and the driver.
It does not appear in the User/System DSN ODBC control panel.
Does not appear in the driver tab
Is listed in the ODBCINST.INI
and appears in the registry

REGEDIT4
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACH INE\SOFTWARE\OD BC\ODBCINST.INI \MySQL ODBC 3.51 Driver]
"UsageCount"=dw ord:0000000c
"Driver"="C:\\W INDOWS\\system3 2\\myodbc3.dll"
"Setup"="C:\\WI NDOWS\\system32 \\myodbc3S.dll"
"APILevel"= "2"
"ConnectFunctio ns"="YYN"
"DriverODBCVer" ="03.51"
"FileUsage" ="0"
"FileExtns"="*. txt"
"SQLLevel"= "1"
"CPTimeout"="60 "
"DSNHelpFile"=" C:\\WINDOWS\\he lp\\my3dsn.hlp"

help

jrt
Jul 23 '05 #1
2 3257
John Thorne wrote:
Windows XP sp2, Installed MyODBC 3.51 and the driver.
It does not appear in the User/System DSN ODBC control panel.
Does not appear in the driver tab
Is listed in the ODBCINST.INI
and appears in the registry


I just tried installing MyODBC 3.51 on my XP sp1 machine (I'm avoiding
SP2), and it worked fine. I see no DSN's defined for MySQL data
sources, but that's to be expected, I think -- I haven't defined any.
I do see MyODBC in the Driver tab.

Perhaps you need to exit the control panel applet for Data Sources
(ODBC) and restart it to see changes to ODBCINST.INI? That's my only guess.

Regards,
Bill K.
Jul 23 '05 #2
Heya John - it won't appear in the User or System DSN panels until you MAKE
a DSN for it.
But -
you don't see it in the driver tab either ? are you sure ?
which install package did you use to install it with ?
and .
do you have admin rights to install stuff on that machine ?
[thats a tough one sometimes] .
hth - mondo regards [Bill]

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

"John Thorne" <jo**@jrthorne. com> wrote in message
news:cdxLd.597$ bF4.474@trnddc0 4...
Hello
Windows XP sp2, Installed MyODBC 3.51 and the driver.
It does not appear in the User/System DSN ODBC control panel.
Does not appear in the driver tab
Is listed in the ODBCINST.INI
and appears in the registry

REGEDIT4
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACH INE\SOFTWARE\OD BC\ODBCINST.INI \MySQL ODBC 3.51 Driver]
"UsageCount"=dw ord:0000000c
"Driver"="C:\\W INDOWS\\system3 2\\myodbc3.dll"
"Setup"="C:\\WI NDOWS\\system32 \\myodbc3S.dll"
"APILevel"= "2"
"ConnectFunctio ns"="YYN"
"DriverODBCVer" ="03.51"
"FileUsage" ="0"
"FileExtns"="*. txt"
"SQLLevel"= "1"
"CPTimeout"="60 "
"DSNHelpFile"=" C:\\WINDOWS\\he lp\\my3dsn.hlp"

help

jrt

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
4826
by: Mr Dygi | last post by:
Hi, PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a problem with this simple code: <?php $link = mysql_connect("127.0.0.1","","") or die("Could not connect: " . mysql_error()); echo "Connected successfully"; mysql_close($link);
11
4204
by: Mike MacSween | last post by:
My client has an MS Access database application on her local machine. I have full access to that in terms of changing the design. I've got a simple PHP/MySql application on shared hosting, so no direct access to the db server. I'd like to give her the facility to export the information in her local Access application to the shared PHP/MySql site. From one command button (or similar) in the Access application.
0
5005
by: Fatt Shin | last post by:
Hi, I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB Connector 3.51. I'm facing a problem where whenever I issue a SELECT COUNT(*) statement from PowerBuilder, I always get SQL syntax error back from MySQL. (Refer to ODBC Trace I captured below). metrohouse af8-b94 ENTER SQLExecDirect HSTMT 014D2360 UCHAR * 0x020A0EA2 "select count ( *) from code
2
3569
by: Duncan Smith | last post by:
Hello, I'm not very experienced in SQL and I need some advice. I have a comma separarated values file containing around 20 million records and about 20 fields. There are many missing values (blank). I am only directly interested in 2 fields (1 & 4), but need to use two other fields (2 & 3) for imputing values for Field 1 (if missing). If Field 4 is missing I must delete / ignore the record. The (Python) types are, Field1 (string) ...
11
17576
by: DJJ | last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL tables to a Microsoft Access 2003 database. I am finding that the data from the MySQL tables takes a hell of a long time to load making any kind linkage with my Access data virtually useless. I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting out on a server and the Access database is running locally. The network connection is very...
2
4928
by: Beda Christoph Hammerschmidt | last post by:
MySQL, Access, ODBC, Replication Hello, i have a central mysql database that is accesed by multiple clients running MS Access with ODBC. This works fine if Access has a permanent connection to mysql. But now, i want MS Access to operate offline (e.g. on notebook in the
1
13896
by: zMisc | last post by:
I am looking at using MySQL in my application (currently works with Access and SQL Server 2000). Is it possible to access MySQL database using ADO? What is the connection string for this? Also, it is possible to change/modify the table structure/create new tables/indexes via Visual basic codes?
9
2476
by: Jacques Lebastard | last post by:
I have a problem writing PHP ODBC scripts that suit both MySQL and PostgreSQL. So far, the following syntaxes seem to apply to each database (this is an 'insert' example; the same differences apply to 'select commands): MySQL: INSERT INTO MyTable (col1, col2) VALUES ("value1","value2") PGSQL: INSERT INTO "MyTable" (col1, col2) VALUES ('value1','value2') I'd like to have a single syntax for both databases. Is this possible? Do I need...
7
5574
by: BillCo | last post by:
I need to Connect to an online mySQL database from Access using JET ODBC with no saved DSN. Anyone out there who as made this work and can give example of how it's done? I've seen lots of posts saying it's possible, but no code. This has to be Jet ODBC, because the users are technophobes and I wouldnt expect them to download and install a myODBC driver - or create a working DSN for that matter. My visiting the sites and configuring...
0
10164
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10110
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9961
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7512
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6745
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5397
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5534
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4066
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3669
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.