ODBC and JDBC Guide

10 FileMaker ODBC and JDBC Guide
Limitations with third-party tools
Microsoft Access: When using Microsoft Access to view data in a FileMaker data source, do not use data
from a summary field. The summary field’s data should not be edited in Microsoft Access, and the data value
that is displayed in Microsoft Access may not be accurate.
Networking requirements
You need a TCP/IP network when using FileMaker Server Advanced to host a FileMaker database file as a
data source over a network. FileMaker
Pro supports local access (same computer) only.
Updating files from previous versions
Installing current drivers
If you installed a driver from prior versions of FileMaker Pro or FileMaker Server Advanced, you must
install the driver for version 11.
The driver for FileMaker version 11 is not compatible with earlier versions of FileMaker Pro or FileMaker
Server Advanced.
For more information on installing drivers, see chapter 3, “Installing FileMaker ODBC client drivers” and
chapter 5, “Installing FileMaker JDBC client drivers.”
Note You have to create a Data Source Name (DSN) for each FileMaker database file you want to access
as a data source. If you have previously set up access through one DSN that allows tables to be spread among
several FileMaker database files, you’ll need to consolidate those tables into a single database file (or create
several DSNs).