AnsweredAssumed Answered

SQL Catalog Underscore Issue

Question asked by AdventureHermit on Mar 10, 2009


SQL Catalog Underscore Issue

Description of the issue

FileMaker Product(s) involved:FileMaker Pro 10.0 Operating System(s) involved:Confirmed on Windows XP/Vista Detailed description of the issue:When using an ODBC connection to remote databases that have underscores in their name, the catalog option fails. Exact steps to reproduce the issue:1. In the Relationships window select New Table2. In the Specify Table window Manage Data Sources3. Select NEW4. Under Edit Data Source select an existing ODBC connection, enter the user and password5. Under Catalog name enter a catalog name6. Save and Exit back to the Relationships windowExpected Result:The selected Catalog table names will appear Actual Result:No table names appear Exact text of any error message(s) that appeared:N/A Any additional configuration information/troubleshooting that is relevant to the issue:1.  Adding the schema name or table name has not effective change on the result Any workarounds that you have found:1. Select an explicit database in the ODBC Connection and do not use the catalog option 2. Make changes using FM 9 where underscores are not a problem 3. Remove the Underscores from the Database names