Fw: MyODBC Driver Not Appearing in Windows XP

Fw: MyODBC Driver Not Appearing in Windows XP

am 21.08.2004 23:55:06 von karusse

----- Original Message -----
From: "Donna and/or Kenneth Russell"
To: "Pradnya Dharia"
Sent: Thursday, August 19, 2004 9:29 AM
Subject: Fw: MyODBC Driver Not Appearing in Windows XP


> This is my response to Christer explaining what solved my MySQL ODBC
> problem.
>
> Kenneth Russell
> ----- Original Message -----
> From: "Donna and/or Kenneth Russell"
> To: "Christer Ljung"
> Sent: Saturday, August 14, 2004 1:52 PM
> Subject: Re: MyODBC Driver Not Appearing in Windows XP
>
>
> > With your help, I found the solution. MYODBC did not appear in the
> Control
> > Panel Driver list. I decided to do a search for ODBCINST.INI and found
> that
> > it did not exist on this PC. I have another Win XP machine and quickly
> > found OBDCINST.INI in it's Windows directory. I found that with a
little
> > hand editing, I could adapt the file from the other PC for use on this
> one.
> > However, I did not have to hand edit or copy the file to this machine.
> >
> > I had installed a trial version of another database application, "File
> Maker
> > Pro" on this machine and it's trial period had expired. I used Control
> > Panel's Add/Remove Programs to uninstall it. After the uninstall, I
found
> > that the system had generated a new OBDCINST.INI file with MYODBC
> referenced
> > from within it. I went to Control Panel's ODBC setup and all worked
well.
> >
> > I don't know what deleted the ODBCINST.INI file from my PC but now
> > everything works.
> >
> > Thank you so much for giving me so much good advice and information.
> >
> > Kenneth Russell
> >
> > ----- Original Message -----
> > From: "Christer Ljung"
> > To: "Donna and/or Kenneth Russell"
> > 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@ix.netcom.com]
> > 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"
> > To:
> > 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@ix.netcom.com]
> > Sent: Friday, August 13, 2004 6:12 PM
> > To: mysql@awarehouse.com; myodbc@lists.mysql.com
> > 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@ix.netcom.com
> >
> >
> >
>


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