User manual

15-4 FileMaker Pro User’s Guide
To configure the ODBC control panel to access FileMaker Pro data
via ODBC:
1. Open the ODBC control panel (named ODBC Data
Sources (32bit) in Windows and ODBC Setup PPC in the
Mac OS).
2. In the User DSN tab, click Add to configure a new data source.
3. Select the FileMaker Pro ODBC driver (named FileMaker Pro in
Windows and ODBC 3.11 FileMaker Pro PPC in the Mac OS) and
click Finish.
Note The Mac OS Appearance Manager extension must be installed
on Mac OS system 7.6.1.
4. In the General tab, type a Data Source Name and Description.
The data source name should be meaningful to others accessing
the data.
5. If you are accessing a remote FileMaker Pro data source, select
Use Remote Connection and provide the IP address of the computer
sharing the FileMaker Pro database.
The FileMaker Pro ODBC driver must be installed on the computer
generating the SQL query.
6. Click OK, or click the Advanced tab to specify additional settings.
See the next section for more information.
You may specify options in other tabs, depending on which control
panel and driver you are working with. For example, the File DSN tab
is used by file-based data sources and can be shared by multiple users
who are using the same type of driver.
Specifying advanced options
Use the Advanced tab in the ODBC FileMaker Driver Setup dialog box
to specify the following optional settings:
After configuring the control panel, you connect to the FileMaker
Pro data source and construct a SQL query in the ODBC client
application. For a list of SQL statements that FileMaker Pro
supports, choose Help menu > Contents and Index, click the Index tab,
and type SQL support.
Note Performing complex queries or retrieving a large number of
records may take time. Consider batching the requests for optimal
performance.
This option Refers to
Max Text Length The maximum length of a column in a specific row
(64000 is the maximum number of characters allowed
in a row). Decreasing this number uses less memory and
can improve performance.
File Open Cache The maximum number of used file handles to cache. By
specifying a value, you are choosing how many tables
to keep open.
Fetch Chunk Size The number of rows that each fetch request (to
FileMaker Pro) uses when the driver scrolls forward
through a rowset. For best results, the number should
match the number of records you’re retrieving.
International Sort The order records are retrieved when you include the
ORDER BY clause. Select to use international sort
order as defined by your operating system.
Clear to use the ASCII sort order (the default setting).
Number, Time, and
Date as Text
The driver treats Number, Date, and Time values as text
rather than numeric data. This preserves all data in a
field, even if the data isn’t the same as the field type.
Applications Using
Threads
Enables the driver to work with multi-threaded
applications. Clear this checkbox if you’re working
with single-threaded applications.
Translate button Translates your data from one character set to another.