Help

Using ODBC and JDBC with FileMaker Server Sharing FileMaker databases via ODBC and JDBC
F
ILEMAKER SERVER 9 HELP 103
Sharing FileMaker databases via ODBC and JDBC
You can use FileMaker Server Advanced to host a FileMaker 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:
1. 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. For more
information, see FileMaker Pro Help.
Note If your FileMaker database solution uses more than one FileMaker database file, all of the
database files must use this privilege set with the extended privilege Access via ODBC/JDBC
enabled.
2. In FileMaker Server Admin Console, click ODBC/JDBC and select Enable ODBC/JDBC.
3. Upload the database file to FileMaker Server. See Hosting databases
(page 31).
Note If your FileMaker database solution uses more than one FileMaker database file, all of the
database files must be hosted on the same FileMaker Server deployment
.
4. On each client computer that needs to access the hosted database, install and configure the
FileMaker ODBC or JDBC client driver
.
For details on installing and configuring a client driver to access your FileMaker data source,
see the F
ILEMAKER ODBC AND JDBC GUIDE on the Start Page.
Related topics
Enabling sharing via ODBC and JDBC (page 104)
Using ODBC and JDBC with FileMaker Server
(page 101)