RE: Trouble Installing MyODBC Connector

Dear Katherine,

Have you tried registering the driver from the command line? I can confirm
that I don't have any special directories created when I install 3.51.x -
I'm on Vista x64 now, so all the files get put in SysWow64 (32-bit
compatibility directory) but on XP they get put in system32. You should have
myodbc3i.exe and myodbc3m.exe among others.

Myodbc3i.exe can be used to register the driver, which might allow you to
pin down where the problem is more accurately.

The command to register the driver can be seen if you type

myodbc3i /?

from the command prompt within the system32 / syswow64 directory. The
example for "register a driver" that they give uses .so files (I think
that's Linux?) but use can use the windows equivalent - I can't remember if
they're the lib files or the dll files. So, something like:

myodbc3i -a -d -t"MySQL ODBC Driver
3.51;DRIVER=c:\windows\system32\myodbc3.dll;SETUP=c:\windows\system32\myodbc
3S.dll"

or

myodbc3i -a -d -t"MySQL ODBC Driver
3.51;DRIVER=c:\windows\system32\myodbc3.lib;SETUP=c:\windows\system32\myodbc
3S.lib"

That should give you a "driver count" - if it's greater than 1, then you
already had the driver registered. If it fails, post the message here and we
might be able to help out. If it succeeds, try using the example (again,
"myodbc3i /?") of creating a DSN from the command line and see what message
you get there:

myodbc3i -a -su -t"DSN=MyDSN;DRIVER=MySQL ODBC 3.51
Driver;SERVER=myServerHostname;UID=myUser"

or (for a system data source rather than a user data source)

myodbc3i -a -ss -t"DSN=MyDSN;DRIVER=MySQL ODBC 3.51
Driver;SERVER=myServerHostname;UID=myUser"

Again, if that gives error messages then maybe post them here..?

Hope that helps,

Al McNicoll
Integritec Limited


-----Original Message-----
From: Simpson, Katherine [mailto:[email protected]] 
Sent: 26 June 2007 00:08
To: Bonnett, John; [email protected]
Subject: RE: Trouble Installing MyODBC Connector

Thanks for your reply - if you have any other ideas, please feel free to
throw them out there.

-Katherine

> -----Original Message-----
> From: Bonnett, John [mailto:[email protected]] 
> Sent: Monday, June 25, 2007 3:57 PM
> To: Simpson, Katherine; [email protected]
> Subject: RE: Trouble Installing MyODBC Connector
> 
> I presume you have actually clicked the Add button? The 
> reason I ask this is because I got caught by something like 
> this when I installed MyODBC. When you open the ODBC dialog 
> in Control Panel you see a list of existing connections. 
> MySQL will not appear there initially. I took that as meaning 
> MyODBC was not correctly installed.
> 
> When you click on the Add button you should see something 
> like "MySQL Connector/ODBC v5" or "MySQL ODBC 3.51 Driver" in 
> the list of drivers.
> If that is not there I don't know what your problem is.
> 
> John Bonnett
> 
> -----Original Message-----
> From: Simpson, Katherine [mailto:[email protected]]
> Sent: Saturday, 23 June 2007 6:24 AM
> To: [email protected]
> Subject: Trouble Installing MyODBC Connector
> 
> Hello List -
> 
> I'm attempting to install the ODBC Connector (I've tried 
> 3.51.12, 3.51.16, 5.0.11) on a Windows XP Pro machine.  The 
> installation seems to be successful, but when I try to add 
> the data source (via ODBC Data Source Administrator) the new 
> driver is not listed.
> 
> When I installed the two different v3 distributions, no path 
> was displayed in the installer and no option to identify the 
> path.  The installer told me the installation succeeded, but 
> I can't find the driver in the data source admin.
> 
> When I installed v.5, the path was verified in the installer 
> (c:\Program Files\MySQL\MySQL Connector ODBC 5.0) and after 
> the installation I found the files there.  But still no 
> driver in the data source admin.
> 
> Any ideas would be greatly appreciated.
> 
> Katherine Simpson
> [email protected]
> 
> No virus found in this outgoing message.
> Checked by AVG Free Edition. 
> Version: 7.5.472 / Virus Database: 269.9.4/860 - Release 
> Date: 6/21/2007
> 5:53 PM
>  
> 
> No virus found in this incoming message.
> Checked by AVG Free Edition. 
> Version: 7.5.472 / Virus Database: 269.9.6/865 - Release 
> Date: 6/24/2007 8:33 AM
>  
> 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.9.6/865 - Release Date: 6/24/2007
8:33 AM
 



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]