Easysoft SQI-Sage Tetra CS/3 Driver User Guide - Configuration

Configuring the Easysoft SQI-Sage Tetra CS/3 Driver

This section explains how to check that the Easysoft SQI-Sage Tetra CS/3 Driver is connecting your Sage Tetra CS/3 data and how to set up additional local data sources on Unix.

Chapter Guide

• Creating data sources
• Querying a data source
• Creating additional data sources
• Obtaining write access to your Sage Tetra CS/3 data

Creating data sources

You can choose to create a data source called TETRA to point at your Sage Tetra CS/3 data when the Easysoft SQI-Sage Tetra CS/3 Driver is installed.

This is used as an example in Querying a data source to illustrate how to validate that a connection has been made after the installation process has been completed.

In addition to the TETRA data source, new data sources may be created, as shown in Creating additional data sources, to:

• allow access to multiple Sage Tetra CS/3 files with the same name and layout, but located in different directories
• provide different sets of permissions and privileges for the same database
• allow groups of files from the same database to be configured differently
• allow multiple copies of the same database to be separately configured
• permit an application into which the data source name has been hard-coded to access a database

A correctly configured data source can then be connected to from any ODBC-compliant application.

Querying a data source

Once you have installed the Easysoft SQI-Sage Tetra CS/3 Driver, you can type SQL queries at the system prompt.

This allows you to test whether or not the Easysoft SQI-Sage Tetra CS/3 Driver is successfully accessing your Sage Tetra CS/3 data.

An Easysoft script called isql is provided to enable you to run the SQL command without needing to set LD_LIBRARY_PATH.

This script determines the LD_LIBRARY_PATH values from a separate configuration file (es.ld.so.conf) and then runs the 'sql' command, specifying the data source to query and the user name and password to use to access the data source.

By default, this script specifies:

• the data source name as tetra (dsn=tetra)
• the user name as manager (uid=manager)
• the password as reganam (pwd=reganam).

If you have different logon details (e.g. if you have changed the password for the manager user, as explained in Administration), edit the script to change those details.

If you have more than one data source, you can create a copy of the isql script for each data source and specify the appropriate data source name in each copy of the script, giving you a script ready to run for querying each data source.

To query a data source using the isql script:

1.  Change into the <InstallDir>/easysoft/sqi/tetra directory.

2.  Type:

./isql

If an 'invalid user' or 'invalid password' error is displayed, check that the script specifies the correct user name and password.

If a line beginning "conn =" is displayed, then the connection has been made and you can type an SQL statement to query the data source.

For example:

select * from sys.sop_order_header;

To finish your SQL session, press <Enter> to return to the system prompt.

Another utility, also called isql, is included in unixODBC, the Open Source ODBC Driver Manager for non-Windows platforms, which is installed with the Easysoft SQI-Sage Tetra CS/3 Driver on Unix.

To run this program, go to the <InstallDir>/easysoft/unixODBC/bin directory and type:

./isql DSN [UID [PWD]] [options]

where

• DSN is the data source name
• UID is the user name
• PWD is the password

Type ./isql only for option details.

Creating additional data sources

If you have more than one Sage Tetra CS/3 data source, any additional data sources must be added manually so that the unixODBC Driver Manager can access them:

1.  Change into the /usr/local/easysoft/sqi/tetra directory.

2.  Open the file dsn_template.sample in an editor.

3.  Edit the following settings:

• replace the data source name, [TETRA] by default, with the name of your data source.
• change tetra_path to point to the directory containing your Sage Tetra CS/3 installation.
• change schema_path to point to the directory containing the schema files of the data source. The schema directory stores information such as users, passwords and privileges set up via the Web Administrator, and any views you have created.

4.  Save the file under a new name.

5.  Change into the /usr/local/easysoft/unixODBC/bin directory.

6.  Type:

odbc_system_dsn=1 ./odbcinst -i -s -ffilename

where filename is the name you chose at step 4.

 This creates a system-wide data source in the odbc.ini file, so that it can be accessed by the unixODBC Driver Manager.

See odbc.ini settings for details of other settings that you can specify in odbc.ini.

odbc.ini settings

If you are running the Easysoft SQI-Sage Tetra CS/3 Driver on a Unix machine, you will probably set up data sources by editing dsn_template.sample (see Creating additional data sources).

However, if you intend to edit odbc.ini directly, you should be familiar with all the data source parameters that can be specified (by default, odbc.ini is located in the /etcdirectory):

Logging options

By including particular settings in your odbc.ini file, you can specify various levels of logging.

To enable logging, include the logfile= and the logging= lines in your odbc.ini file:

• logfile= specifies the directory path and the filename prefix to which the log file is generated. The log filename takes this prefix and the process id. For example, if you set logfile=/tmp/tetra then the log filename will be something like tetra_026503.log.
• logging= specifies the required level of logging. The values you can set it to are:
  
  

  Log Number	Log Description
  1	logs entry to all functions and attributes to all calls in the SQI layer
  2	logs exit from all functions
  4	logs information regarding the file cache
  8	logs information on opening of files and how many reads are performed
  16	logs any expression checking that the SQI layer performs
  32	logs any errors reported at the SQI layer
  64	logs the selection of indexes used when starting a query
  128	logs summary information about the SQI function calls

You can enable multiple logging options simply by adding the values together. For example, for entry, exit and expression logging, 1+2+16=19.

Obtaining write access to your Sage Tetra CS/3 data

The Easysoft SQI-Sage Tetra CS/3 Driver includes a facility for the manager user to obtain write access to the Sage Tetra CS/3 data.

This means, for example, that the manager user could display Sage Tetra CS/3 data in Microsoft Access, make changes to it, then save the changes back to the Sage Tetra CS/3 data source.

To enable write access for the manager user, include the following settings in the odbc.ini file (remove these lines or set them to 0 to disable write access).