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
Chapter 2
|
Using ODBC to share FileMaker data 17
Additionally, you’ll need to specify these keyword values for the DSN:
Important If you attempt to add a DSN with the ODBC 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. The download provides an ODBC Administrator that allows you to successfully
create a DSN. See www.filemaker.com/odbc for links to additional details.
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.