The various FairCom SQL APIs and Drivers supported by FairCom DB Standalone SQL Service include:
The documentation for installing and configuring these drivers/APIs is available at the links provided above.
These documents reference operation using the FairCom DB SQL Server, however the same details also apply to using them with FairCom DB Standalone SQL Service. The following topic is based on material from the FairCom DB SQL ODBC Driver Guide, which has been modified to be specific for FairCom DB Standalone SQL Service: Configuring the ODBC Data Source.
Configuring the ODBC Data Source
Installations on Microsoft Windows require that the FairCom ODBC driver be installed. If you installed c-tree using the Windows .msi file installer, this was done for you. If you installed using a ZIP file, you will need to use the FairComConfig tool (typically found in the FairCom tools\setup folder) to install the FairCom ODBC driver yourself, as described in a subsequent section. If you are running on Linux, you do not need to install the ODBC driver.
Determining if the FairCom ODBC Driver Is Installed
From your Microsoft Windows System Control Panel, under Administrative Tools, open the Data Sources (ODBC) tool. Note that newer versions of Windows list this tool as ODBC Data Sources:
You should see the FairCom ODBC Driver installed.
The FairCom ODBC Driver needs to be listed in two different places. Firstly, it needs to be listed in the User DSN tab, as show here:
Secondly, the FairCom ODBC Driver needs to be listed in the Drivers tab, as shown here:
If the FairCom ODBC Driver is not listed in both of these places, install it using the steps detailed in the following section.
Installing the FairCom ODBC Driver
If the FairCom ODBC driver is missing from the above two lists, you need to install it using the FairComConfig tool.
Be sure the FairCom ODBC Driver is installed, as indicated in the following image:
Once you have configured the FairCom ODBC Driver, you may need to exit and then restart the ODBC Data Sources administrative tool to refresh and list the FairCom ODBC Driver on both of its tabs.