ODBC and JDBC Guide
Table Of Contents
- Chapter 1 Introduction
- Chapter 2 Accessing external SQL data sources
- Chapter 3 Installing FileMaker ODBC client drivers
- Chapter 4 Using ODBC to share FileMaker data
- Chapter 5 Installing FileMaker JDBC client drivers
- Chapter 6 Using JDBC to share FileMaker data
- Chapter 7 Supported standards
- Chapter 8 Reference Information
- Index
Chapter 1 | Introduction 9
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 12.
The driver for FileMaker version 12 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).