External data source not working FMS9A

November 26, 200817 yr

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.

November 27, 200817 yr

Author

bump

1 month later...

January 23, 200916 yr

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.

January 24, 200916 yr

Author

No, it's still not working.

January 28, 200916 yr

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. )