ODBC and JDBC Developer’s Guide

10 FileMaker ODBC and JDBC Developer’s Guide
See FileMaker Pro Help for details about sharing via ODBC/JDBC, and for setting up accounts and
privilege sets.
Note In previous versions of FileMaker Server and FileMaker Pro, you needed to create only one DSN
(Data Source Name) for the host application when configuring a driver for access via ODBC. The one DSN
allowed you to access any of your FileMaker database files as a data source. Beginning with
FileMaker
Server 7 and FileMaker Pro 7, you must create a DSN for each individual 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).
If you previously used FileMaker Pro as a client to access a data source
The drivers you configured to access the data source should still work. See www.filemaker.com/odbc for
links to third-party vendors providing updated drivers. Additionally, Windows includes client drivers, such
as SQL Server driver, with the operating system.
Important On Mac OS, OpenLink iODBC drivers conflict with the drivers provided in earlier versions of
FileMaker. If you install the OpenLink iODBC drivers, you can no longer use the Text, Oracle, or SQL
Server drivers included in earlier versions of FileMaker
Pro.
See FileMaker Pro Help for details about using FileMaker Pro to access other data sources via ODBC.