How to create an ODBC DSN for FileMaker 7
Note #1: This technical note is written for Windows, there is a separate technical note for MacOS X.
Note #2: When installing a 32bit FileMaker ODBC driver for a 32bit version of FileMaker on a 64-bit version of Windows, you need to open the 32bit ODBC administrator in order to create or update the ODBC DSN. The FileMaker ODBC driver will not appear in the list of drivers within the default 64bit ODBC administrator app, because it is not a 64bit ODBC driver. If you run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32.exe. To indicate the type of DSN, you can add "_32" to the 32-bit user DSNs and "_64" to the 64-bit user DSNs.
FileMaker Pro 7 for Windows includes the DataDirect SequeLink ODBC driver which only allows a connection to the database from the localhost IP address - from the computer running the database. Unlike previous versions of FileMaker, the FileMaker ODBC driver is no longer automatically installed along with the database software. A separate ODBC installer is launched from the xDBC folder on the FileMaker 7 CD in order to install the ODBC driver. Launch the DataDirect setup.exe installer from the on the FileMaker 7 installation CD. The default installation options may be used during the install process.
[Figure 1 - FileMaker 7 ODBC Installer]
Due to a problem with the ODBC installer, the DataDirect
SequeLink software needs to be installed twice in order to work correctly
In order to access a FileMaker 7 database via ODBC, the ODBC/JDBC Sharing Feature needs to be enabled for the FileMaker 7 database.
[Figure 2 - Enabling FileMaker 7 ODBC/JDBC Sharing]
Open the Windows Data Sources (ODBC) Control Panel to
create a new FileMaker 7 System DSN. Click the System DSN tab, then
click the Add button.
Select DataDirect 32Bit SequeLink 5.4 as the driver for
the new FileMaker 7 data source, then click the Finish button.
[Figure 4 - Select DataDirect 32Bit SequeLink 5.4 Driver]
Enter the name of the ODBC DSN in the first field. Fill
in the SequeLink Server Host (127.0.0.1), and SequeLink Server Port
(2399) fields as shown in the image below.
[Figure 5 - Enter SequeLink Driver Parameters for FileMaker 7]
In order to verify that a connection can be made to the FileMaker 7 database, it is a good idea to test the ODBC connection before attempting to use the new ODBC DSN. DataDirect has provided a helpful Test Connect button within their driver setup window which will enable testing of ODBC database connectivity.
Click the Test Connect button shown in Figure 15 to verify
that a connection can be made to the new FileMaker 7 database.
[Figure 6 - Test FileMaker 7 ODBC DSN]