Fw: MyODBC Driver Not Appearing in Windows XP

----- Original Message ----- 
From: "Donna and/or Kenneth Russell" <karusse@xxxxxxxxxxxxx>
To: "Pradnya Dharia" <pradnya@xxxxxxxxxxx>
Sent: Thursday, August 19, 2004 9:27 AM
Subject: Fw: MyODBC Driver Not Appearing in Windows XP


> This is the second note I received from Christer r.e. MySQL ODBC.
> 
> Kenneth Russell
> ----- Original Message ----- 
> From: "Christer Ljung" <christer@xxxxxxxxxxxx>
> To: "Donna and/or Kenneth Russell" <karusse@xxxxxxxxxxxxx>
> Sent: Saturday, August 14, 2004 12:13 PM
> Subject: RE: MyODBC Driver Not Appearing in Windows XP
> 
> 
> To begin with, it wasn't my intent to reply directly to you, but the
> MySQL list sends out the postings that way - sorry for that, I forgot to
> change To:! Anyway, as we got started this way...
> 
> If you open Control Panel/Admin Tools/Data Sources (ODBC) and go to the
> "Drivers" tab, you should see the RegKey name MySQL ODBC 3.51 Driver
> (from directly under ODBCINST.INI, since that's what the applet is
> listing. If not, this is something new to me and I truly have no idea
> what's going on your machine.
> 
> If you do see it, you should be able to see/select it when you click the
> Add button in the "System DSN" tab. This step is needed to setup your
> datasource (actually, there is a thing called DSN-less connect strings
> that let's you skip this, but that's a side story).
> 
> >I have installed other ODBC drivers without any problems.  Are there
> other
> >references to ODBC drivers in the registry that may be missing or
> >incomplete?
> 
> There are no other regkeys that an ODBC driver should set. If it has its
> subkey under ODBCINST.INI and also has "Installed" under
> ODBCINST.INI\ODBC Drivers, it is installed. The reason I suspect your
> registry is inconsistent is that I've fought this error before. The
> MySQL ODBC driver is a multi-platform driver which is unique amongts
> ODBC drivers. The installation procedure has been known to be flaky.  
> 
> > Will it help if I delete the MySQL driver from "ODBCINSI.INI"
> 
> No, If its there as you say, it should be enough. Do not delete as this
> will leave you with problems for all your other drivers.
> 
> > Windows\System32, not Windows\Help
> 
> This may vary from machine to machine, although I don't know why. It
> really should be in Windows\Help to be a good citizen, but that's
> another story.
> 
> /Christer 
> 
> PS.
> DSN-less connect strings do not need a User/System DSN registration
> since the ODBC driver (provider) is pointed out directly. First example
> is DSN-based, second is DSN-less. Sorry for the lecture!
> 
> Data Source=MySystemDSNname;Server=localhost;Initial Catalog=test;User
> ID=mrx;Password=*******;
> 
> Provider={MySQL ODBC 3.51 Driver};Server=localhost;Initial
> Catalog=test;User ID=mrx;Password=*******;
> 
> DS.
> 
> 
> -----Original Message-----
> From: Donna and/or Kenneth Russell [mailto:karusse@xxxxxxxxxxxxx] 
> Sent: Saturday, August 14, 2004 7:42 PM
> To: Christer Ljung
> Subject: Re: MyODBC Driver Not Appearing in Windows XP
> 
> Christer,
> 
> Thank you very much for your response.  When I checked my registry,
> under
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI], there was an existing
> key
> "MySOL ODBC 3.51 Driver".  It only contained three entries; UsageCount,
> Driver and Setup.  I hand edited the MySQL key to include all of the
> parameters you listed in your note.
> 
> I also checked the sub-key "ODBC Drivers" and it showed that the MySQL
> driver was installed on the system.
> 
> However, the Control Panel/Admin Tools/Data Sources (ODBC) module still
> does
> NOT show the MySQL ODBC driver.  I shut down and restarted the PC to be
> sure
> that the new regustry entries would be used.  Nothing changed.  It seems
> as
> though the Control Panel module is not reading the registry to update
> the
> list of installed ODBC drivers.
> 
> I have installed other ODBC drivers without any problems.  Are there
> other
> references to ODBC drivers in the registry that may be missing or
> incomplete?
> 
> Will it help if I delete the MySQL driver from "ODBCINSI.INI" and use
> your
> "cut and paste" technique to replace the MySQL key into the registry?
> If I use the "cut and paste" routine, should the line "REGIT4" be
> included
> the text to be imported into the registry?
> 
> One final minor point.  Prior to editing the registry, I searched for
> the
> help file "my3dsn.hlp" and found that the driver install program placed
> it
> in Windows\System32, not Windows\Help.  I modified the registry key
> entry to
> point to Windows\System32.  You may wish to tell other clients to copy
> the
> file to Windows\Help before importing the MySQL ODBC key, as you have
> it,
> into their registries.
> 
> Again, thank you very much for your help.
> 
> Kenneth Russell
> Vallejo, California, USA
> ----- Original Message ----- 
> From: "Christer Ljung" <christer@xxxxxxxxxxxx>
> To: <myodbc@xxxxxxxxxxxxxxx>
> Sent: Friday, August 13, 2004 11:37 AM
> Subject: RE: MyODBC Driver Not Appearing in Windows XP
> 
> 
> Might be that driver isn't registered. Verify that you have the below in
> your Registry. If not cut-n-paste from REGEDIT4 (below) into Notepad,
> save it as *.reg and then double-click on it to import it into the
> Registry.
> 
> Once this is done you can configure your data source in Control Panel >
> Administrative Tools > Data Sources (ODBC).
> 
> 
> REGEDIT4
> 
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 3.51 Driver]
> "UsageCount"=dword:0000000c
> "Driver"="C:\\WINDOWS\\system32\\myodbc3.dll"
> "Setup"="C:\\WINDOWS\\system32\\myodbc3.dll"
> "APILevel"="2"
> "ConnectFunctions"="YYN"
> "DriverODBCVer"="03.51"
> "FileUsage"="0"
> "FileExtns"="*.txt"
> "SQLLevel"="1"
> "CPTimeout"="60"
> "DSNHelpFile"="C:\\WINDOWS\\help\\my3dsn.hlp"
> 
> 
> /Christer
> 
> -----Original Message-----
> From: Donna and/or Kenneth Russell [mailto:karusse@xxxxxxxxxxxxx]
> Sent: Friday, August 13, 2004 6:12 PM
> To: mysql@xxxxxxxxxxxxxx; myodbc@xxxxxxxxxxxxxxx
> Subject: MyODBC Driver Not Appearing in Windows XP
> 
> I have the same problem referenced in several recent postings on the
> MYODBC list.  I downloaded and installed the 3.51 version of MYODBC into
> Windows XP Pro with Service Pack 1a.  The install seemed to go without
> problems. However, in the Control Panel/ODBC module, the MYODBC driver
> is not listed.  I have confirmed that the two "dll" files and the "lib"
> file are present in the Windows/System32 directory.  Also, I totally
> uninstalled the driver and reinstalled it with the same results.
> 
> In the MYODBC archive, I did not see any solution to this problem.  Can
> anyone help?
> 
> Thank you.
> 
> Kenneth Russell
> 
> 
> -- 
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=karusse@xxxxxxxxxxxxx
> 
> 
> 

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx