Hi, I'm using sql 2005 express(32bit, x86) on windows 7 enterprise(64bit). I want to set up a link server for mysql.
I downloaded and installed the mysql-connector-odbc-5.1.8-win32.msi, mysql odbc connector drvier. I run this and it seeems to install no problem.(any other step after this?) I then run odbc32ad.exe, click on the the System DNS, but there is no odbc driver for me to select. There is only "sql native client" and "sql server".
I check the local drive, C:\Program Files (x86)\MySQL\Connector ODBC 5.1, and there is several files in there folder including some dlls, pdb and a "myodbc-installer.exe". Do I need to run this installer exe again? I double click on it and it flases a cmd dialog box then closes it very quickly. How can I get this driver installed? Thanks.