ODBC Setup Dialog Options

The c-tree ODBC Driver is optimized to simplify setup. The c-tree ODBC Setup dialog box is accessible from the Windows Control Panel ODBC icon or your ODBC compliant application and provides the following options as shown in the following:

Data Source Name

Arbitrary database (application view) name.

Description

Arbitrary description of database.

Script Name

Default: FAIRCOM.DB

Database script file name. See “Building a FairCom Data Dictionary Script”. This prompt is not case sensitive. See additional notes in “FairCom Data Dictionary - In Depth”.

Server Name

Default: FAIRCOMS

The c-tree Server name. The default may be overridden with the SERVER_NAME keyword in ctsrvr.cfg. If you are not sure of the name of your c-tree Server, contact your network administrator or consult ctsrvr.cfg in your c-tree Server directory.

When using TCP/IP, the Server Name must include the c-tree Server host machine name. Both the Server Name and host name are case sensitive. The format is: Server_Name@Server_Hostname, where Server_Name is the name of the c-tree Server and Server_Hostname is the name of the machine running the c-tree Server. Consult your network administrator for more information.

For example, to connect to a machine with a hostname of Sun and using the default Server name FAIRCOMS, specify the following Server Name:

FAIRCOMS@Sun

Allow Updates

Default: NO

Enabling this feature allows writes, or inserts, into files available to the c-tree ODBC Driver.

Note: By enabling this option, you will be responsible for maintaining the integrity of your c-tree Plus data. The authors of your c-tree Plus based application have taken extreme care to ensure the integrity of your c-tree Plus data files. For example, in an accounting system, an order total may be the sum of several individual products. If you override the price of one of the products and do not adjust the order total accordingly, the data integrity could be compromised. If you are unsure about the ramifications of enabling this write feature, consult the software vendor from whom your c-tree Plus based application was purchased.

Number of Files

Default: 200

Maximum number of concurrently open c-tree Plus files (data plus index).

Driver Type

Select the I/O operational mode for the c-tree ODBC Driver. The choices are: