MySQL ODBC driver

[K N]

Which is the recommended current version of MySQL ODBC driver to be used to connect to repository in MySQL?

I am aware that it should be 32-bit version.

When downloading the latest from the following link http://dev.mysql.com/downloads/connector/odbc/

it cannot be setup correctly. When adding the driver in ODBC configuration, it shows up as "MySQL ODBC driver 5.2 Unicode" and "MySQL ODBC driver 5.2 ANSI".

What could be the reason for this?

Thanks
KN

[Dermot]

Check the user guide page on this:
http://www.sparxsystems.com/enterprise_architect_user_guide/10/projects_and_teams/setupmysqlodbcdriver.html
This states 5.1.5.

[K N]

Thanx Dermot!!!

will try with that version.

[Ian Mitchell]

Is the 5.2 driver version likely to be supported at some point? I've just stumbled into this bear-trap....

[qwerty]

I remember having had quirks with the MySQL driver version in the past. Some people in the group had one driver and others a newer one. The problem was that the needed options had moved in the driver GUI. So it was harder to tell which ones to enable. So be sure to have one tested driver version and make this the official standard (people think to be smart when loading the latest one from the internet).

q.