External data source not working FMS9A

[HALBURN]

I created a solution on my local computer that connects to an external MySQL data source.

Everything works great until I try to host the solution on a remote server running FMS9A. When I try to connect to the file I get the following error (see attached).

I have configured and tested both the server and the client computer via the Mac OS X ODBC administration utility. They can both connect to the MySQL data source without any problems.

Any help or suggestions would be greatly appreciated.

[HALBURN]

bump

[jbernal]

Did you make any progress on this? It's been a few months so I don't want to reply if you've already figured it out.

[HALBURN]

No, it's still not working.

[Baloo]

The client ODBC connector is irrelevant for hosted solutions.

Is the server Tiger or Leopard?

Which version of MySQL's connector are you using? (You want 3.51 not 5.1)

Is the DNS on the Server User or System? (there was/is a bug that causes the Mac ODBC manager to create MySQL DSNs as User rather than System. It's fixed in Leopard. If you're on Tiger there are command line tools for configuring the DSN that will work. )