CODEWITHSUNDEEP
mysqlms-accessodbcwindows-server-2008-r2
Ford
Ford

Reputation: 1

Server 2008r2 x64 and ODBC Connector

server 2008r2 x64, mysql 5.5.24 x86, access 2007 x86

im trying to connect mysql backend to access 2007 frontend...

after I installed mysql-connector-odbc-5.1.12-win32.msi and rebooted server. that driver will not show up in the drivers tab of ODBC Datasource administrator.or in the list of drivers if i try to add a new driver

also installed mysql-connector-odbc-5.2.5-win32.msi also just to try newer version, that does not show up either. repaired both install, rebooted, reinstalled, same thing. all i see is a mysql driver...

any ideas whats going on?

UPDATE:

Used C:\Windows\system32\odbcad32.exe and same results.. no driver there...

really not sure whats going on... any special dependancies required? not sure what i could be missing.. as i said, neither driver is visible, yet both installed without error (to my knowledge, are there install logs???)

default path for both drivers during installation was c:\programs Files (x86)\MySQL\connector ODBC 5.1\ or c:\rograms Files (x86)\MySQL\connector ODBC 5.2\

any thoughts?

Upvotes: 0

Views: 7892

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123484

After installing 32-bit ODBC components onto a 64-bit machine you need to run the 32-bit ODBC Administrator, normally found at

C:\Windows\SysWOW64\odbcad32.exe

If you just go the normal Control Panel > Administrative Tools > Data Sources (ODBC) route then you will be looking at the 64-bit environment, and your 32-bit options will not be visible.

Upvotes: 2

Related Questions