Help

Using ODBC and JDBC with FileMaker Server Sharing FileMaker databases via ODBC and JDBC
F
ILEMAKER SERVER 9 HELP 104
Enabling sharing via ODBC and JDBC
FileMaker Server Advanced can host data via ODBC/JDBC for other applications (like
spreadsheets, word processors, and reporting tools). Users can view, analyze, and modify data in
hosted FileMaker databases. To host data, you must enable this feature in FileMaker Server Admin
Console and use FileMaker Pro to enable sharing via ODBC/JDBC in each database that you want
to share.
For more information, see Sharing FileMaker databases via ODBC and JDBC
(page 103).
Note Sharing via ODBC/JDBC requires a FileMaker Server Advanced license.
To enable sharing via ODBC/JDBC:
1. Choose ODBC/JDBC.
2. Select Enable ODBC/JDBC.
3. Click Save.
Notes
• Enabling this feature allows clients to use FileMaker Server as a data source via ODBC and
JDBC. You do not need to enable this OBDC/JDBC data source feature to host
FileMaker Pro databases that access an external SQL data source via ODBC. See
Accessing external ODBC data sources
(page 105).
• For other applications to access FileMaker data hosted on FileMaker Server, ODBC and
JDBC client drivers
must be installed on the machines running the other applications.
Installers for the client drivers are provided on the FileMaker Server CD or you can
download them.
• You must use FileMaker Pro to enable ODBC/JDBC sharing in each database you want to
share. For details about sharing via ODBC/JDBC, see FileMaker Pro Help.
• For more information on installing the client drivers and for details on the SQL
statements
supported by FileMaker Server Advanced, see the F
ILEMAKER ODBC AND JDBC GUIDE on
the Start Page.
Related topics
Uploading database files (page 33)
Email notification settings
(page 57)
Database Server security settings
(page 70)
Server information settings
(page 55)