Database profiles registry entry
Contents
Database profiles for all data sources are stored in the
registry in
HKEY_CURRENT_USERSOFTWARESybasePowerBuilder22.0DatabaseProfiles.
Editing
You should not need to edit the profiles directly to modify
connection information. These files are updated automatically when
PowerBuilder creates the database profile as part of the ODBC data
source definition.
You can also edit the profile in the Database Profile Setup
dialog box or complete the Database Preferences dialog box in
PowerBuilder to specify other connection parameters stored in the
registry. (For instructions, see Setting Additional
Connection Parameters)
Example
The following example shows a portion of the database profile
for an Demo Database data source:
|
1 2 3 |
DBMS=ODBC DBParm=ConnectString='DSN=PB Demo DB V2022R2 DB;UID=dba;PWD=00c61737' Prompt=0 |
This registry entry example shows the two most important values
in a database profile for an ODBC data source:
-
DBMS
The DBMS value (ODBC) indicates that you are using the ODBC
interface to connect to the data source. -
DBParm
The ConnectString DBParm parameter controls your ODBC data
source connection. The connect string must specify the DSN (data
source name) value, which tells ODBC which data source you want to
connect to. When you select a database profile to connect to a
data source, ODBC looks in the ODBC.INI registry key for a subkey
that corresponds to the data source name in your profile. ODBC
then uses the information in the subkey to load the required
libraries to connect to the data source. The connect string can
also contain the UID (user ID) and PWD (password) values needed to
access the data source.