Configuring PROIV to connect to SQL Server

Virtual Machine

You can connect PROIV to SQL Server database in three methods:

Method 1: Update PROIV.ini file with the following configuration

When you install an ODBC option, each database that is being connected to requires an ODBC data source setup. Additionally, each user should have the following variables declared in their pro4v[n].ini, Environment section.

[ENVIRONMENT]

<RDBMStype>_SELECT_FOR_UPDATE=TRUE
SQL_DBNAME=<odbc system datasource name>

[DATABASE - SQLDEFAULT]
FILETYPE=<RDBMStype>
CONNECTION=<username>/<password>

Where <RDBMStype> is "SQLSERVER"

For Windows: This setting assumes that your ODBC data source is configured as a System Data Source, not a User Data Source. If it is not, go to Control panel, ODBC Data Sources and select the System DSN tab. Click Add to create a new data source and select the driver as SQLServer.

Method 2: Select SQL SERVE option for External Database Support during PROIV installation.

Refer to PROIV V8.2 Installation guide for more information.

Method 3: Configure SQL SERVE database using PROIV Control Panel

Open PROIV Control Panel > Virtual Machine > Database

The DATABASE - SQLDEFAULT page appears. Click here for more information.

Comment on this topic

Topic ID: 560005