Sharing FileMaker Pro databases via ODBC and JDBC
You can use FileMaker Server to host a FileMaker Pro database file as a data source, sharing your data with other applications using ODBC and JDBC. FileMaker Server allows up to 50 connections and supports local access (same computer) and remote access (both for middleware such as web servers and for remote client access from desktop productivity applications).
To share a hosted FileMaker Pro database via ODBC and JDBC:
- In FileMaker Pro, open the database and edit the privilege set for the accounts that will access the database. Enable the extended privilege Access via ODBC/JDBC. See FileMaker Pro Help.
Note If your FileMaker Pro database solution uses more than one FileMaker Pro database file, all of the database files must use this privilege set with the extended privilege Access via ODBC/JDBC enabled.
- In FileMaker Server Admin Console, click the Connectors > ODBC / JDBC tab, then set ODBC / JDBC to Enabled.
- Upload the database file. See Hosting databases
Note If your FileMaker software solution uses more than one FileMaker Pro database file, all of the database files must be hosted on the same FileMaker Server deployment.
- On each client computer that needs to access the hosted database, install and configure the FileMaker ODBC or JDBC client driver.