ODBC and JDBC Developer’s Guide
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Using ODBC to share FileMaker data
- Chapter 3 Using JDBC to share FileMaker data
- Chapter 4 Supported standards
- Appendix A Mapping FileMaker fields to ODBC data types
- Appendix B Mapping FileMaker fields to JDBC data types
- Appendix C ODBC and JDBC error messages
- Index
Using ODBC to share FileMaker data 17
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.
Accessing a FileMaker database file from a Mac OS application
If you build custom applications, use version 3.52.1 of the iODBC headers and libraries. Applications built
with version 3.51 might not be able to load the client driver.
Installing the ODBC client driver (Mac OS)
You can download the latest version of the ODBC client driver and PDFs of FileMaker 7 ODBC
documentation from www.filemaker.com/odbc. See the Installing FileMaker ODBC and JDBC Client Drivers
PDF file for information.
To install the ODBC client driver, copy the file SequeLink.bundle to either your System or User library. If you
don’t have an /ODBC folder, create one manually:
Configuring the ODBC client driver (Mac OS)
Configure the client driver using the ODBC Administrator bundled with the iODBC driver manager software
recommended for your client application. If you require the OpenLink ODBC Administrator, it is bundled with
the ODBC-JDBC Lite Bridge download available on the OpenLink web site.
The client driver has been tested with the following iODBC driver managers:
1 OpenLink ODBC Administrator 3.52.1 (available from OpenLink Software)
1 Apple ODBC Administrator 1.0.1 (available with Mac OS 10.3)
When configuring the client driver, you’ll be prompted to provide a brief description and the path to the driver
file:
The ODBC Administrator also allows you to optionally define keywords and a Setup File path, but the client
driver does not need that information.
Library Copy SequeLink.bundle to this folder:
System /Library/ODBC
User /Users/<user>/Library/ODBC
If you copied SequeLink.bundle
to this library: Use this driver path during configuration:
/Library/ODBC /Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk18.dylib
/Users/<user>/Library/ODBC /Users/<user>/Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk18.dylib