skip to main content
Configuring Security for OpenAccess SDK : Configuring OpenAccess SDK security : Storing client credentials : Storing credentials in the Windows registry
 
Storing credentials in the Windows registry
The following keys are added:
*For a user data source:
HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\<dsname>\LogonId
HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\<dsname>\Password
*For a system data source:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<dsname>\LogonId
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<dsname>\Password
The oaencpwd.exe utility is installed in the Client's installation directory. This utility allows the customer to enter an encrypted password in the registry and optionally add a LogonId. The LogonId is stored a plain text, the Password is encrypted. Note that the credentials are always sent over the wire in encrypted form.

C:\>oaencpwd
OpenAccess SDK Client for ODBC (tm) Utility to store an encrypted password in a Data Source
Choose System DSN [S] or User DSN [U].
Choice: [U] ==> U
Enter Data Source Name: OA810_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=OA810_mydsn : Password (PWD) stored encrypted.
Would you like to store a LogonID (UID) as well? [Y] [N]
Choice: ==> Y
Enter LogonID (UID):odbc
DSN=OA810_mydsn : LogonID (UID) stored.