Initialisation File Settings for SQL Databases

Two sections of the pro4v[n].ini file require entries for connecting to SQL databases. They are described below.

Logical Path Definition

SQL files are viewed as logical paths and the logical paths can be specified in the File Definition.

When no logical path is specified SQL files, by default, look into a logical path name SQLDEFAULT, for example:

[DATABASE - SQLDEFAULT]
FILETYPE=file-type
CONNECTION=connection-string

When a logical path is specified in the PROIV File Definition, the path can be described in the following way. If the logical path for the file is PAYROLL and the alternate file name is %PAYROLL%EMPLOYEE

The entry in the initialisation file is:

[DATABASE - PAYROLL]
FILETYPE=ORACLE
CONNECTION=bill/billpassword@t:ntmach:orcl
(the old way by TWO_TASK)

To connect to multiple SQL databases, a logical path name must be specified in the alternate file name in the PROIV File Definition.

Comment on this topic

Topic ID: 750027