ODBC and JDBC Guide

Chapter 4 | Using ODBC to share FileMaker data 23
To change the existing ODBC client driver:
1. In the ODBC Data Source Administrator, select the System DSN or User DSN tab (select the
tab used when you previously configured).
2. Choose the FileMaker data source that you previously configured.
The data source name you originally entered appears under Name, and FileMaker ODBC
appears as the Driver.
3. Click Configure.
The FileMaker DSN Configuration dialog box appears.
4. For Name, enter a name that will be meaningful to others accessing the FileMaker data source.
For Description, enter an optional description of the FileMaker data source. Click Next.
5. For Host, enter the location of your data source.
If you’re connecting to a FileMaker database file hosted by FileMaker Pro on your local
machine, type
127.0.0.1 (or localhost).
If you’re connecting to a FileMaker database file hosted by FileMaker Server Advanced over a
network, type the IP address of FileMaker Server.
If you’ve enabled sharing via ODBC/JDBC in the host application, select Connect to host to
obtain the names of available databases.
6. For Database, select a database from the list of available databases, or type the filename of
the FileMaker database file you’re using as a data source.
Note For database files hosted by FileMaker Server Advanced, the list of databases may be
filtered based on the File Display Filter setting. See FileMaker Server Help for information.
If you need special handling of non-English text, click Advanced Language. The Advanced
Language Options dialog box opens.
1 To auto-detect language settings, select the Auto-detect language settings for
application option.
1 To specify the language setting, clear the Auto-detect language settings for application
option and select the system setting you want to use.
Select the Describe text fields as long varchar option to correct issues with long field values,
such as fields that do not have a maximum length specified getting used for Microsoft Word Mail
Merge import, or field values in PHP applications that are longer than 255 characters.
If you want to create a log file for long-running queries, select the Save long-running queries
to a log file option, and enter the name for the log file.
7. Click Finish to save your data source information.
8. Click Done to close the FileMaker DSN Configuration dialog box.