ODBC Data Sources; can't add MySQL Driver

Question

I want to connect MS Access with MySQL. I installed Xampp for MySQL and now I installed the ODBC driver 5.3. I went to Data Sources and clicked on System-DSN to add the MySQL ODBC 5.3 Driver (like shown in this video https://www.youtube.com/watch?v=F06hvR6ksh4). But there wasn't any MySQL ODBC 5.3 Driver. My OS is Windows 7 Home x64. How can I connect the ODBC Driver to the MySQL Server?

score 5 · Accepted Answer · answered Jun 29 '15 at 07:47

5

If you try to use 32bit MySQL ODBC connector on 64bit Windows, you need to use 32bit Data Sources (c:\Windows\SysWOW64\odbcad32.exe).

answered Jun 29 '15 at 07:47

Andrei

882
8
13

score 0 · Answer 2 · answered Jun 23 '15 at 09:07

0

You might haven't installed ODBC Connector for MySQL yet. Install it first then add MySQL to the ODBC. Check here for the connector you need http://dev.mysql.com/downloads/connector/

answered Jun 23 '15 at 09:07

Dewanta

208
1
9

That's the one I installed. Connector/ODBC 5.3.4 – Ceel Jun 23 '15 at 12:22

score 0 · Answer 3 · answered Jun 25 '15 at 06:59

0

I just installed the older version and it worked.

answered Jun 25 '15 at 06:59

Ceel

13
1
4

ODBC Data Sources; can't add MySQL Driver

3 Answers3