Open the ODBC Administrator found in ‘Applications > Utilities’ and select ‘Add’, this will bring up a dialog listing the drivers that are currently installed on the system. Select ‘FileMaker ODBC’ from the list and select ‘OK’. This will bring up a wizard; select ‘Continue’ and the dialog below will be shown.
In the ‘Name:’ field enter the name of the data source (this is the name that will be used in the connection string). It is also possible to set a description for the data source however this is not mandatory.
In the ‘Host:’ field enter the location of the host, if FileMaker is being run on a local machine set this to ‘localhost’.
In the ‘Database:’ field enter the name of the FileMaker Database file.
In this window check if the details are correct and then select ‘Test’, this will test the ODBC connection to FileMaker.
The default User/Pass for FileMaker is ‘Admin’, no password. If the test fails and displays ‘[FileMaker][FileMaker] Failed to connect to listener (2)’ then ODBC sharing will need to be set up in FileMaker.
To do this navigate to ‘File > Sharing > ODBC/JDBC’, this will open up a dialog which will give the option to turn sharing on.
The connection should now be successful, if so the connection in EasyCatalog can now be setup (see Setting up EasyCatalog to use an ODBC data source for details on how to do this).
