Setup

The setup is a combination of installation and post-installation processes. The installation allows PROIV to connect to a single SQL database after installation. Procedures in this document allow PROIV to connect to multiple heterogeneous databases.

The following information must be provided to PROIV to ensure successful connection to a SQL database.

File Type - Set the file type based on the database. For example, FILETYPE = MYSQL / SQLSERVE / POSTGRES / ORACLE.
Connection string - The connection information to the database. For example, the Oracle connection string consists of userid/password@host-string as in pro4user/pro4pwd@t:pro4:orcl.
DLL Name - Each database access sub-module is created as a DLL (Dynamic Load Library). Where there are multiple versions (for example, PROIV supports Oracle versions 11g and 12c) the DLL name must be provided to PROIV. This information is provided in the initialisation file using the "ORACLE_DLLNAME=" environment option.
Initialisation File - The Windows kernel looks at two initialisation files.

- Global Initialisation file - pro4v[n].ini located in the Windows directory.

- User specific initialisation file - which can be located in any directory.

One file per user is allowed. The location of the user specific initialization file must be specified in the user section of the global initialisation file. The user-specific initialisation file can contain user-specific environment settings and logical database path settings. The user specific file should not contain a [USER] section, and if one exists, the contents are ignored.

SQL database specific commands are searched in both initialisation files.

Comment on this topic

Topic ID: 720219