ODBC - c-tree Plus Edition

Script Method

By creating a simple text script, the FairCom Data Dictionary can be created automatically upon the first access to the c-tree ODBC Driver by an ODBC compliant application. A sample text script, FAIRCOM.DB, is included and is placed in the installation directory (C:\FAIRCOM\ODBC\32bit by default). The format of the text script is as follows. alias_name is the symbolic file name referenced from an ODBC application. file_name is the actual file name as it resides on disk, including the directory structure.

alias_name file_name

The text file should list the file alias names and the actual file names on a separate line for each file (see “Additional tips for the ctree Server Script” for an example).

The steps to create the FairCom Data Dictionary using the script method are:

1. Create the script with the format defined above.
2. Specify the name of the script with the Script Name setting in the c-tree ODBC Driver setup window.
3. Set the Data Dictionary Path setting in the Options section of the c-tree ODBC Driver setup window to the directory where the script resides.
4. With the script in place, when the first ODBC compliant application accesses the c-tree ODBC Driver, the FairCom Data Dictionary, CTSYSCAT.FCS, will be created from the information located in the script file. The FairCom Data Dictionary will be created in the Data Dictionary Path in multi-user non-server mode or in the c-tree Server directory when using the c-tree Server.

After successfully creating the dictionary, the text script is no longer needed.

Note: A third method for creating the FairCom Data Dictionary is available for advanced users. This method is to use the import.exe utility shipped with the c-tree ODBC Driver. See “Data Dictionary Creation - Import Method” for additional information.