ODBC and JDBC Guide

Table Of Contents

Chapter 4 | Using ODBC to share FileMaker data 21

If the connection is successful, 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 fmxdbc extended privilege for

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 a macOS application

Specifying ODBC client driver properties for a FileMaker DSN (macOS)

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 (macOS)” on page 16.

Verifying access via ODBC (macOS)

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 DSN you originally entered appears under Name, and FileMaker ODBC appears as the

Driver.

4. Click Configure.

5. Click Continue until you reach the Conclusion page.

6. Click Test.

Enter your FileMaker account name (in Database User Name) and password (in Database

Password).