MySQL ODBC driver problems - Solution

[Rüdiger Engelberger]

Hi,

I had troubles with MySQL server 5.1 and specific ODBC driver versions.

So for possibly saving your time I want to tell you which combinations work and which don't.

MySQL Server 5.1

MySQL ODBC 5.2 -> doesn't work
MySQL ODBC 5.1.12 -> doesn't work
MySQL ODBC 5.1.6 -> works (!!!)

5.1.6 is not available on the official download page anymore but you can find it at:

http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-5.1&v=5.1.6

Rüdiger Engelberger

[hd]

MySQL ODBC 5.1.12 works fine for me, on a 5.1.52 community server.

Have you set the 2 options listed in item 7 on page...
http://www.sparxsystems.com/enterprise_architect_user_guide/9.3/projects_and_teams/setupmysqlodbcdriver.html

Make sure you have the 32-bit driver installed, and set it up from C:\Windows\SysWOW64\odbcad32.exe

[Rüdiger Engelberger]

Hi,

I have 5.1.40 community server installed and it didn't work at all with MySQL ODBC 5.1.12. I could create an ODBC datasource, test it successfully but when I tried to connect in Enterprise Architect I always got:

Provider [-2147418113]
Schwerwiegender Fehler

(which means: fatal error)

This only occured when installing MySQL ODBC 5.1.12. I set the options correctly in the ODBC datasource configuration. If you don't set them then you only get annoying error messages when working in EA but it basically works.

Then we downgraded to 5.1.6 and it worked perfectly. This behaviour occured on 4 different workstations so I'm quite sure that this was the reason.

Rüdiger Engelberger

[Stefan Bolleininger]

5.1.9-win32 works perfectly in my environments

[seritalien]

Hello,

Mysql 5.5 with ODBC 5.2.6 works like a charm