Connecting Using Saved Login Information

The ODBC client supports the use of a preconfigured user name and password which is used if the client application does not supply a user name and password. The information is stored using the oaencpwd tool, which is located in the installation directory.

The login credentials for the ODBC Client can be stored in the registry on Windows or in the odbc.ini file on UNIX. This allows the customer to logon without specifying credentials. On Windows, LogonID and Password registry keys are added. On UNIX, the LogonID and Password attributes are added for the data source in the odbc.ini. The LogonId is stored as plain text, and the Password is encrypted.

The driver looks for a stored user ID and password in the Registry or odbc.ini file only when no valid values are specified, such as a NULL or non-existent value. The driver does not look for a stored user ID and password when the values are left blank, that is when UID=; PWD=; is specified in the connection string.