- 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. For more details about file definition see Files and Data in PROIV Developer.

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

An Oracle logical path can be described as:

[DATABASE - SQLDEFAULT]
FILETYPE=ORACLE
CONNECTION=bill/billpassword@t:ntmach:orcl

CONNECTION=bill/billpassword@ntmach

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

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

For MySQL:

[DATABASE - <database_name>]
FILETYPE=MYSQL
PRODB_CHARSET=8
CONNECTION="username/password@host:portnum/dbname" ["root/root007@127.0.0.1:0/p4testdb"]
where host is the machine ip address or the host name.

Comment on this topic

Topic ID: 720113