Configuration Procedures

Connection String Keywords

The PxPlus SQL ODBC Driver recognizes keywords as part of a connection string. The format is keyword=value (case insensitive) with multiple entries separated by ; (semi-colon).

Example:

DSN=MyDSN;UID=John;PWD=foo;Company=ABC

The keywords are listed below:

Keyword

Description

DSN

Name of the DSN to use for default values.

FileDSN

Name of the file DSN to use for default values.

Driver

Name of the Driver to use (DSN-less connection).

Description

(Optional) Description of the DSN.

InstallDir

(UNIX/Linux Only) Directory in which the ODBC Driver was installed.

(InstallDir support was added in PxPlus 2020.)

Directory

Directory containing the providex.ddf file if defining local DSN. See Configure Data Source Name (DSN).

Note:
The Directory setting must not include the data dictionary file name. (The providex.dde file is not required by the PxPlus SQL ODBC Driver.)

Example:

If the providex.ddf file is located at /pxp/data/providex.ddf, then use /pxp/data.

IniFile

Directory and file name of the INI file to be used if defining local DSN. See Configure Data Source Name (DSN).

Note:
The IniFile setting must include the INI file name.

Example:

If the INI file is located at /pxp/data/mydata.ini, then use /pxp/data/mydata.ini.

Prefix

Data search prefix

RemotePVKIOHost

Server name or IP address of the server.

RemotePVKIOPort

Port that the server is monitoring.

Catalog

Name of catalog. A catalog defines a remote data dictionary and/or INI file and optionally a prefix if defining remote DSN. See Configure Data Source Name (DSN).

A maximum number of 256 catalogs may be defined.

(Catalog support was added in PxPlus 2018.)

Compression

Using ZLib compression to minimize network traffic between the client and the server.

Company

Company code

UID

User ID

PWD

Password

SID

Session ID

ViewDLL

Location of the Views DLL/SO

BurstMode

0 - Burst mode off
1 - Burst mode on

DirtyReads

0 - Dirty read off
1 - Dirty read on

Debug

0 - Debug output off
1 - Debug output on

Silent

0 - Silent off
1 - Silent on

KeyRestrict

0 - Report key columns
1 - Disable reporting of key columns

EnforceDouble

0 - Do not force numerics to double
1 - Report all numerics as double

EnforceNullDate

0 - Null date off
1 - Null date on

StripTrailingSpaces

0 - Do not strip trailing spaces from key values when joining multiple tables
1 - Strip trailing spaces from key values when joining multiple tables

(StripTrailingSpaces support was added in PxPlus 2017.)

ReadOnly

0 - Connection may allow write access
1 - Connection will deny write access

LegacyNULL

0 - Columns are defined as not nullable
1 - Columns are defined as nullable and empty strings are returned as null

(LegacyNULL support was added in PxPlus 2017.)

LogFile

Path and name of the file to which to write debug output.