# 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

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