ODBC and JDBC Guide

Table Of Contents
Chapter 1 | Introduction 8
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 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 earlier versions of FileMaker Pro or FileMaker Server, you must install
the driver for version 14.
The driver for FileMaker version 14 is not compatible with earlier versions of FileMaker Pro or
FileMaker Server.
For more information on installing drivers, see chapter 3, “Installing FileMaker ODBC
client drivers,” and chapter 5, “Installing FileMaker JDBC client drivers.”
Notes
1 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).
1 For information on using ODBC and JDBC with previous versions of FileMaker Pro, see
http://www.filemaker.com/documentation.