18 FileMaker ODBC and JDBC Guide
10. If you’ve enabled sharing via ODBC/JDBC in the host application, click the button to the right of Server
Data Source to display the filenames of currently open FileMaker database files for you to choose from.
If your database name contains spaces, replace them with the escape characters %20. For example,
serverdatasource=MY%20DATABASE.
11. Click OK to save your data source information.
If you’re sharing another FileMaker database file, return to step 3 and set up the database file as a data
source.
12. Click OK to close the ODBC Data Source Administrator dialog box.
Verifying access via ODBC (Windows)
To verify that you’ve correctly configured the ODBC client driver to access the FileMaker data source:
1. Open the ODBC Data Source Administrator control panel.
In the Windows Control Panel, choose Administrative Tools > Data Sources (ODBC).
In Windows XP, Administrative Tools appear in the Performance and Maintenance category.
2. Click the System DSN tab.
If you set up your data source as a User DSN or File DSN, click the corresponding tab.
3. Choose the FileMaker data source that you previously configured.
The data source name you originally entered appears under Name, and DataDirect 32-BIT SequeLink 5.5
appears as the Driver.
4. Click Configure.
The DataDirect SequeLink for ODBC Setup dialog box appears.
5. Click Test Connect.
You are prompted to enter your FileMaker account name (in Database User Name) and password (in
Database Password).
If the connection is OK, you’ll receive the message Connection test was successful. 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 Pro or FileMaker Server host application has been set up for sharing via
ODBC/JDBC.
