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
18 FileMaker ODBC and JDBC Developer’s Guide
Specifying ODBC client driver properties for a FileMaker DSN (Mac OS)
Create a DSN for each individual FileMaker database file you want to access as a data source (in previous
versions of FileMaker Server and FileMaker Pro, you created only one DSN for all FileMaker database files
hosted by the application). The DSN identifies the FileMaker ODBC driver, the location of the host
application, and the FileMaker database file you’re accessing as a data source.
Important The ODBC client driver for Mac OS does not support upper-ASCII, double-byte, or Japanese
characters in database names or table names. If your FileMaker database file uses these characters, create a
second database and use only ASCII characters for the filename and table names. In the second database, create
a file reference that points to the data in your original database file. Share both files with ODBC/JDBC, but
use the second database file when defining the DSN.
Additionally, you’ll need to specify these keyword values for the DSN:
Important If you attempt to add a DSN with the iODBC Administrator and receive the message Could not load
the driver or translator setup library
, download and install the ODBC-JDBC Lite Bridge (m6I5jzzz.dmg) from
OpenLink's web site.
Verifying access via ODBC (Mac OS)
The OpenLink ODBC Administrator allows you to verify that you’ve correctly configured the ODBC client
driver to access the FileMaker data source.
Keyword Value
Host If you’re connecting to a FileMaker database file hosted by FileMaker Pro on your local machine,
type localhost (or 127.0.0.1).
If you’re connecting to a FileMaker database file hosted by FileMaker Server over a network, type
the IP address or hostname of FileMaker Server.
Port Type 2399.
ServerDataSource
Type the filename of the FileMaker database file you’re using as a data source (don’t type the
filename extension). If your database name contains spaces, replace them with the escape
characters %20. For example, ServerDataDource=MY%20DATABASE. Double-byte
characters are not supported.