AnsweredAssumed Answered

Choose Database via ODBC to SQL Server

Question asked by rbachman@enovapremier.com on Sep 19, 2017
Latest reply on Sep 19, 2017 by user19752

I am trying to connect FileMaker applications as clients via a SQL Server ODBC connection. The applications are hosted by FileMaker Server running on Windows Server 2012. If I choose "Change the default database to:" within the DSN and select a database on the server, everything works fine; however, this means that I have to configure different DSN entries for every database on a given server. If I do not specify the default database within the DSN, I can only view the "master" database on the server when I try to add tables to the relationships graph, and I cannot see tables from any other database on the server. Is there a way to select a database for the FM graph without selecting the default database in the DSN?

Outcomes