FairCom DB Standalone SQL Service

Installation

Installing FairCom DB Standalone SQL Service is a simple process. The set-up program will copy several files to your system, install FairCom DB Standalone SQL Service to run as a service, and start the service.

FairCom DB Standalone SQL Service can be installed on any node of your system as long as it can connect to the data files used by your FairCom Multi-User Standalone (FPUTFGET) database. For best performance, it is recommended to install FairCom DB Standalone SQL Service on the same node as the data files used by the Multi-User Standalone database.

How to Install FairCom DB Standalone SQL Service on Windows

To install FairCom DB Standalone SQL Service on the Windows platform, follow these steps:

1. Copy the file named FairCom-DB-StandAloneSQL*.msi to the computer where you want this service to run.
2. Double-click the file to begin the installation process.

   If Windows pops up a dialog box with a title similar to "Open File - Security Warning," make sure you are executing the file you received directly from FairCom and click Run.

3. The FairCom DB Standalone SQL Service setup wizard will appear. Click Next to begin the installation and answer any questions on the subsequent pages. You can accept the default path (recommended) or select a different drive and directory.
4. On the final page, click Install to begin the installation. A status bar will show your progress. When it is done, click Finish.

How to Install FairCom DB Standalone SQL Service on Unix

FairCom DB Standalone SQL Service for Unix is typically distributed as a zipped tar file containing the executable, faircom_sql_service, and utility programs discussed throughout this guide.

On Unix, FairCom DB Standalone SQL Service can be installed in any directory location as long as ownership and permissions permit access to the installed programs and data.

1. Change to the directory where you want to install the FairCom DB Standalone SQL Service.
2. Copy the FairCom-DB-StandAloneSQL* package into the local directory.
3. Expand the .tgz file

   gzip -d FairCom-DB-StandAloneSQL*.tgz

   tar -xvf FairCom-DB-StandAloneSQL*.tar

4. faircom_sql_service can be started like any other Unix program. It can also be started when the operating system loads.

Installing the Drivers

FairCom DB Standalone SQL Service can support several relational APIs (ODBC, JDBC, ADO.NET, etc.). Each API has its own requirements for drivers. The next step is to install the FairCom DB driver(s) of interest by following these procedures:

1. Copy the desired driver file (for example, FairCom-DB-ODBC*.msi) to any computer(s) where you have applications that need to access your FairCom DB data using that driver.
2. Double-click the file to begin the installation process. Follow the same process described in steps 2 through 4 above.
3. Details for each supported API are available in the API specific books available on the FairCom Web Site in the Documentation section.

The next sections detail some files to be aware of. The next chapter, Driver Setup, explains how to configure the drivers.

In This Chapter The Configuration File The ctcfgset File License Authorization File Excel Example