ODBC and JDBC Guide

Chapter 4 | Using ODBC to share FileMaker data 22
1 Make sure your FileMaker account uses a privilege set with the extended privilege of Access
via ODBC/JDBC.
1 Verify that the FileMaker Server or FileMaker Pro host application has been set up for sharing
via ODBC/JDBC.
Accessing a FileMaker database file from an OS X application
Specifying ODBC client driver properties for a FileMaker DSN (OS X)
Create a DSN for each FileMaker database file you want to access as a data source. The DSN
identifies the FileMaker ODBC client driver, the location of the FileMaker host application, and the
FileMaker database file you’re accessing as a data source.
For information on creating a DSN, see “Configuring client drivers (OS X)” on page 16.
Verifying access via ODBC (OS X)
To verify that you’ve correctly configured the ODBC client driver to access the FileMaker data source:
1. Launch the ODBC Manager utility. (The ODBC Manager is located in the Utilities folder in the
Applications folder.)
2. Select the System DSN or User DSN tab (select the tab used when you previously configured).
3. Choose the FileMaker data source that you previously configured.
The data source name you originally entered appears under Name, and FileMaker ODBC
appears as the Driver.
4. Click Configure.
The FileMaker DSN Configuration dialog box opens.
5. Click Continue until you reach the Conclusion page.
6. Click Test.
You are prompted to enter your FileMaker account name (in Database User Name) and
password (in Database Password).
If the connection is OK, you receive the message Test completed successfully.
If the connection fails:
1 Make sure the FileMaker database file is hosted and available.
1 Update or correct your connection information.
1 Make sure your FileMaker account uses a privilege set with the extended privilege of Access
via ODBC/JDBC.
1 Verify that the FileMaker Server or FileMaker Pro host application has been set up for sharing
via ODBC/JDBC.