Jump to content
Sign in to follow this  
Quang

fields has comma in Windows 2003 MySQL odbc

Recommended Posts

After setting System DSN odbc driver, verify MySQL database connection, and see MySQL tables; I went into FileMaker 9 and added ODBC datasource from my newly created MySQL odbc source.

When I selected my tables, all of my field name shows up with comma in front of the field name in FileMaker 9. And in browse mode, all of my fields has "[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-standard-log]Unknown column ',anyfieldhere' in 'field list'

I guess the reason for the error because of the comma "," somehow created in front of the fieldname when I added the external MySQL odbc.

What am I doing wrong?

Any help is greatly appreciated

Share this post


Link to post
Share on other sites

Which ODBC driver? I got very confused trying out MySQL connections -- I finally realized that the driver that's in the filemaker installer DMG is not apparently the good one -- you you should be using this: http://www.actualtechnologies.com/filemaker.php Perhaps I missed a critical piece of documentation, but it seems like FM is doing a terrible job of explaining this...

Share this post


Link to post
Share on other sites

On the Mac, using ActualTechnology's ODBC works great. But on Windows(I'm using 2003 Server), the ODBC driver 3.51.17 is giving me the comma problem.

Since my FileMaker is hosted on Windows, I can not use ActualTechnology's odbc.

Please help.

Share this post


Link to post
Share on other sites

Found the problem. So far, FM 9 on Windows only works with MySQL ODBC 3.51.16, anything else before that doesn't even show up in FM 9, the latest version 3.51.17 gave me the comma problem mentioned.

Thanks

Share this post


Link to post
Share on other sites

The driver certified by FileMaker (cf the online doc ) is 3.51.14 available here . The driver 3.51.17 got bugs ( here and there for example)

Edited by Guest

Share this post


Link to post
Share on other sites

That's weird. mysql odbc driver 3.51.14 or 3.51.15 didn't work for me. No data showed up

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.