Storing client credentials in the odbc.ini file

The oaencpwd utility is installed in the tools directory of the driver's installation directory. This utility allows you to enter an encrypted password in the odbc.ini and, optionally, to add a LogonId.

The following keys are added to the odbc.ini:

LogonId=my_logonid
Password=my_password_in_encrypted_format

The LogonId is stored plain text while the Password is encrypted. Note that the credentials are always sent over the wire in encrypted form.

$ ./oaencpwd
OpenAccess SDK Client for ODBC (tm) Utility to store an encrypted password in a Data Source
Enter Data Source Name: OA900_mydsn
Choose which password to encrypt and store.
[1]=Password (PWD)
[2]=DBPassword (DBPWD)
[3]=HPassword (HPWD)
[4]=NewPassword (NPWD)
Choice: [1] ==> 1
Enter Password (PWD) (keystrokes are not shown):
DSN=OA900_mydsn : Password (PWD) stored encrypted.
Would you like to store a LogonID (UID) as well? [Y] [N]
Choice: ==> Y
Enter LogonID (UID):my_logonid
DSN=OA900_mydsn : LogonID (UID) stored.