ODBC data sources troubleshooting
Missing data
 •
 •
 •
If a data source name or database is renamed or removed, <Data Source Missing> is displayed.
 •
 •
If FileMaker cannot identify a unique key for an ODBC table or view, <Primary key missing> is displayed in the relationships graph and in field objects.
Note  FileMaker automatically tries to identify a unique key for an ODBC table or view. If FileMaker cannot identify a unique key, when you Sync or add a new ODBC table, a FileMaker dialog box appears where you can specify one or more columns to use as a unique key. If FileMaker still cannot determine unique values for every record in the external table or view at that time, you see <Primary key missing>. If someone working outside FileMaker software associates a new primary key with the external table, the new primary key will be used instead of the key specified in FileMaker.
ODBC errors
 •
 •
For ODBC imports and Execute SQL script steps, if an error occurs while performing a SQL query, the Get(LastError) function returns FileMaker error 1408. The Get(LastODBCError) function returns detailed information about the error. If there is no information about the error, the Get(LastError) function returns FileMaker error 1409.
 •
 •
Find results
Find results for ODBC tables might differ from FileMaker find results on the same data. For example, Asian text in an external table might be collated differently and give different find results than the same text in a FileMaker table.