ODBC data sources troubleshooting
• If a table is renamed or removed from an external database, <Table Missing> is displayed.
• If a column is renamed or removed from the external database table, <Field Missing> is displayed.
• If a data source name or database is renamed or removed, <Data Source Missing> is displayed.
• If the connection fails, the appropriate error message for connection failure is displayed, and <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.
• If the name of a column in an external table is a FileMaker reserved word or a SQL keyword, an ODBC error might result. (For example, an error might result if a column is named “Number” or “Timestamp.”) See About naming fields and Using a reserved word or symbol for a field or table name for more information about FileMaker reserved words. To avoid schema naming problems with ODBC data sources, see the documentation that came with your data source software.
• 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.