Why doesn't FileMaker Pro see my OpenLink DSNs?

The FileMaker Pro ODBC Drivers installer installs another ODBC Driver Manager which gets in front of the iODBC Driver Manager (shipped with Mac OS X 10.2 and 10.3, and updated or installed by OpenLink with all our drivers for Mac OS X). This is due to the way FileMaker Pro was built.

You can disable the Driver Manager installed by FileMaker, to make full use of your OpenLink drivers; please note that this will also disable the ODBC Drivers from DataDirect which shipped with FMPro. It is up to you whether you disable or remove these components. You can re-install these components at any time, by re-running the installer found at /Applications/FileMaker Pro 6 Folder/FileMaker ODBC Drivers/FileMaker Pro ODBC Drivers.

Please open a Terminal window (the Terminal application is in the Utilities subfolder of the Applications folder), and execute the commands which correspond to your desired result. The first sudo command will prompt for your Mac OS X User password -- you must be an Administrator of this Mac to proceed.

To Disable --

     cd /Library/CFMSupport/
     sudo mkdir ../CFMSupport\ (Disabled)
     sudo mv FileMaker* ../CFMSupport\ (Disabled)
     sudo mv ODBC* ../CFMSupport\ (Disabled)

To Re-enable --

     cd /Library/CFMSupport\ (Disabled)/
     sudo mv * ../CFMSupport

To Remove --

     sudo rm -R "/Library/Documentation/Help/DataDirect Help.help"
     sudo rm -R "/Applications/DataDirect ODBC folder"
     sudo rm "/Library/Preferences/fdodbc.lic"
     sudo rm "/Library/CFMSupport/FileMaker*"
     sudo rm "/Library/CFMSupport/ODBC*"