Enabling sharing via ODBC/JDBC
FileMaker Server 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.
To enable sharing via ODBC/JDBC:
1. Click the General Settings > ODBC/JDBC tab.
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.
• 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 your FileMaker installation disk or electronic download in the xDBC folder.
• 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 information on installing ODBC and JDBC client drivers, see
FileMaker ODBC and JDBC Guide on the
Start Page.
• For details on the
SQL statements supported by FileMaker software, see
FileMaker SQL Reference on the Start Page.
Related topics