I have setup a Filemaker Development Server. In the same computer the server is loaded onto, I have setup a System DSN for an SQL database, and I can add tables from this database onto the relationship tab of Manage Database. My issue is that the search I am performing is a bit slow, so I figured I would delve into the Execute SQL script step as I read that this can be quicker.
My issue is that when I try and specify the ODBC Data Source the 'Select ODBC Data Source' window has no entries. If I go to File>Manage>External Data Sources I can see the DSN from the server ok. I am I missing something obvious here, or am I unable to use the DSN set in external data sources in the execute SQL scripts?