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

This table lists the keywords:

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.
SSL	0 - Unencrypted TCP/IP communication 1 - SSL encrypted TCP/IP communication (SSL support was added in version 8.00.0000/PxPlus 2024.)
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