Can't add MySQL data source into External Data Sources...???

November 30, 200718 yr

I just sat down for the first time to try and add a MySQL database into FM using the new External Data Sources features in FM9. I've created my MySQL DB, I also created a System DSN for it on my local machine.

I then went into FM and went to File-Manage-External Data Sources. I clicked New, then selected ODBC, but when I click on Specify for the DSN the only things that show up in the list are Access and DataDirect sources. The MySQL DSN doesn't show up in the list.

I checked the documentation which states that MySQL is supported. What am I missing here?

I've attached a screenshot of my System DSN tab showing the DSN configured and also of FM's dialog where it doesn't show up in the list.

Any information would be greatly appreciated. Thanks!

Edited November 30, 200718 yr by Guest

December 4, 200718 yr

I had this same problem and solved it.

Your post didn't mention installing mysql connector, I'm assuming you already know about that step and have done it.

http://www.mysql.com/products/connector/odbc/

This is what happened to me, I installed the connector, and Mysql still did not show up on my System DSN list and I was baffled. I eventually found this thread on the mysql forum:

http://forums.mysql.com/read.php?37,31449,31449#msg-31449

As it turns out, this is a glitch with the mysql connector installation (I think) but it doesn't affect everyone. The fix is to locate a registry entry, export it, do some manual editing, and import the saved changes. All of the instructions are detailed in the mysql forum thread link above.

Good Luck... so far, I like using FM with Mysql, but I haven't had enough spare time to do any thorough testing.

December 4, 200718 yr

Author

Actually I was just coming back to update that like usual, this was a case of user error for me.

Our FM files are running off FMSA9 and I'm using Open Remote to connect to the files. Well, for some reason my brain just wasn't all there, and I was configuring the MySQL DSN on my local machine that I had FMP opened up on instead of on the server which is where it should have gone.

I have matching DSN's configured for everything else so I just didn't even realize what I was doing until it just hit me. So yeah, write moron on my forehead. B)