I'm trying to connect to a MySQL (4.0.16) database from FileMaker 8.5. I've downloaded and installed the MySQL ODBC connector from mysql.com and configured it in ODBC Administrator. When I try to specify the datasource in the Execute SQL script step and enter the username and password, I get the following error: ODBC Error:[iODBC][Driver Manager]Specified driver could not be loaded.

I've tried different passwords and get the same error. The user I've specified exists and has the proper privs set. I can connect to the MySQL server using any other tool (CocoaMySQL, command line, etc), from any host.

Anybody know what I'm doing wrong here? Do I need to configure anything on the MySQL server to make this work?

I started using the MySQL ODBC drivers and found them very inconsistent. They would work for awhile and then stop. On some Macs they would not even show up when installed.

I was spending too much time trying to solve the problem and tested the Open Source Drivers from Actual Technologies which worked. I eventually purchased the drivers and have been using them for a couple of months without any problems.

http://www.actualtechnologies.com/product_opensourcedatabases.php