|
|
|
|
|
|
The FairCom Database Engine is designed for ease of deployment and administration. In many cases, a deployment can simply copy the server executable and configuration, start the server process and walk away for unattended operation. Described below are the specific files and options available for the deployment process to successfully install the FairCom database engine as part of an OEM total package deployment.
Required Executable Files to Copy
The required FairCom server files will be found in the \server directory. The files listed below are the only required files for a FairCom database engine installation. These can be placed together in any single directory with appropriate permissions.
FairCom Configuration File
A FairCom configuration file provides directives for various server options. This file typically resides in the same directory as the server executable, however, it may be located elsewhere and pointed to by either a command line option when starting the server, or an environment variable (refer to the FairCom Database Engine Server Administrator's Guide for details).
FairCom Administrator Utilities
The following executables are provided for the FairCom administrator. These can be located in a central secured location to protect the integrity of the FairCom installation.
Many other administrator utilities are available, including statistics monitoring, administrator utility, and backup and restore utilities. These are located in the \tools directory of the FairCom installation. The suite of GUI based utilities is also available for distribution.
Note: The FairCom restore utility, ctrdmp.exe, is available from the command-line tools included in the tools folder.
FairCom Java Environment
FairCom SQL Stored Procedures and Triggers require a functioning Java environment. This is not supplied with the FairCom installation and should be obtained and installed independently. Java 6 (1.6) is the recommended Java framework. Three (3) server configuration environment settings specified in ctsrvr.cfg enable these features by providing the paths for the required Java components.
To create stored procedures requires the full Java SDK with the javac.exe compiler. To execute stored procedures and triggers requires only the Java run-time engine (JRE).
The ctreeSQLSP.jar file is required for creating or executing Java stored procedures and triggers and will be found in the \bin\ace\sql\classes directory of the default FairCom DB installation. This file can be installed wherever appropriate for your installation and is referenced with the above configuration.
FairCom as a Windows Service
There are several options available to install the FairCom database engine as a Windows Service.
>sc <windows UNC> create "FairCom DB Database Engine" binPath= c:\FairCom\faircom.exe start= auto DisplayName= "FairCom DB Database Engine"
[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\faircom.exe]
Note: Use caution when specifying that the service can interact with the desktop. Newer versions of Windows do not allow service interaction and any displayed windows that require interaction will "hang" the server as they will not be displayed.
|
|
|
The FairCom DB ADO.NET Driver integrates directly into the Microsoft Visual Studio Development environments.
Files Installed:
Registry Keys
The following Windows registry keys are are required to integrate the FairCom SQL ADO.NET Data Provider into Visual Studio.
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\14.0_Config\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C77}]
@=".NET Framework Data Provider for FairCom"
"Codebase"="C:\\Users\\Craig\\Desktop\\FairCom-DB.windows.64bit.v12.0.0.113.201103.ACE\\FairCom-DB.winX64.v12.0.0.113\\drivers\\csharp.sql.ado.net\\ctree.visualstudio.data.dll"
"Description"="Provider_Description, Ctree.VisualStudio.Data.Resources"
"DisplayName"="Provider_DisplayName, Ctree.VisualStudio.Data.Resources"
"InvariantName"="Ctree.Data.SqlClient"
"ShortDisplayName"="Provider_ShortDisplayName, Ctree.VisualStudio.Data.Resources"
"Technology"="{77AB9A9D-78B9-4ba7-91AC-873F5338F1D2}"
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\14.0_Config\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C77}\SupportedObjects]
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\14.0_Config\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C77}\SupportedObjects\DataConnectionProperties]
@="Ctree.VisualStudio.Data.FcDataConnectionProperties"
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\14.0_Config\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C77}\SupportedObjects\DataConnectionSupport]
@="Ctree.VisualStudio.Data.FcDataConnectionSupport"
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\14.0_Config\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C77}\SupportedObjects\DataConnectionUIControl]
@="Ctree.VisualStudio.Data.FcDataConnectionUIControl"
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\14.0_Config\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C77}\SupportedObjects\DataObjectSupport]
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\14.0_Config\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C77}\SupportedObjects\DataSourceInformation]
@="Ctree.VisualStudio.Data.FcDataSourceInformation"
[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\14.0_Config\DataProviders\{0EBAAB6E-CA80-4b4a-8DDF-CBE6BF058C77}\SupportedObjects\DataViewSupport]
GAC (Global Assembly Cache)
Register the \drivers\charp.sql.ado.net\Ctree.Data.SqlClient into the .NET Framework GAC using the GACUTIL.EXE utility provided by Microsoft.
.NET Framework machine.config Update
Make the following additions to the machine.config .NET framework configuration file found in the following Windows directory:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\CONFIG
Add the following XML tags:
|
|
|
The FairCom ODBC Driver installer registers the driver into the Windows ODBC Administrator and create a data source. Below are specific registry entries required for installation of the driver:
Driver
[ HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI ]
"FairCom ODBC Driver"
Data Source
[ HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\FairCom ODBC Driver ]
"FairCom ODBC Driver"
|
|
|
The FairCom DB SQL JDBC driver is a full type 4 (native Java) JDBC driver, and as such, is platform independent. The FairCom DB SQL JDBC Driver jar file is located in the following FairCom DB installation directory:
This file can be located anywhere in an application installation and is referenced solely with an appropriate Java CLASSPATH specification. For example:
The FairCom JDBC Driver file requires no changes to any other system component.
