AnsweredAssumed Answered

FileMaker Crash while managing ODBC external source

Question asked by fredhaze on Jan 28, 2011
Latest reply on Mar 1, 2011 by TSGal

Summary

FileMaker Crash while managing ODBC external source

Product

FileMaker Pro

Version

11.0.2

Operating system version

OSX 10.5.8

Description of the issue

I am using the FMpro 11.0v2 demo version. I would like to use MySQL tables served from a Ubuntu server.

Manage Relationships shows the tables of a ODBC data source but then returns a
"ODBC Error: [MySQL][ODBC 5.1 Driver][mysqld-5.1.41-3ubuntu12.9]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''myodbcdatasource" at line 1

Trying again, selecting a database table (with '_') in the table name, crashes FileMaker Pro.

The ODBC data source tests correctly, i can select table content at will with SQL queries in other programs besides FM. A number of crashes have been reported to Apple. Please tell me if i can be of help?

A trace is available, but i couldn't find a way to attach it :)

Steps to reproduce the problem

see above

Expected result

see above

Actual result

see above

Exact text of any error message(s) that appear

see above

Configuration information

OSX 10.5.8; FMPro 11.ov2; unixODBC driver

Workaround

None found

Outcomes