ConnectString
database parameter
Description
Specifies the parameters required to connect to an ODBC data
source. PowerBuilder uses these parameters to connect to the
database.
Applies to
ODBC
Syntax
The ConnectString syntax displays on a single line. You must
enclose the entire ConnectString in single quotes and separate
parameters within the ConnectString with semicolons.
|
1 |
ConnectString='DSN=data_source_name; {UID=user_ID; PWD=password; driver_specific_parameters}' |
|
Parameter |
Description |
|---|---|
|
data_source_name |
A name that identifies the data |
|
user_ID |
(Optional) The user ID required to connect to the |
|
password |
(Optional) The password required by user_ID to |
|
driver_specific_parameters |
(Optional) Any other driver-specific parameters |
Default value
None
Usage
PowerBuilder generates the ConnectString automatically when you
define an ODBC data source and copies it to the Preview box in the
Database Profile Setup dialog box. This happens before you connect to
the data source in PowerBuilder.
Therefore, you do not have to enter the ConnectString yourself
when defining an ODBC data source. However, you might need to edit the
ConnectString value in the Database Profile Setup dialog box.
You can change the ConnectString parameter if necessary by editing
it in the Database Profile Setup dialog box. For example, if you change
the name of an existing ODBC data source, edit its database profile to
update the connect string with the new DSN (data source name)
value.
Examples
Example 1
This example shows a connect string for an ODBC data source that
contains the data source name (DSN=Sales), user ID (UID=dba), and
password (PWD=sql). Parameters within the connect string are separated
by semicolons.
-
Database profile
On the Connection page in the Database Profile Setup dialog
box, select Sales from the Data Source drop-down list, select the
User ID check box and type dba, and select the Password check box
and type sql. -
Application
Type the following in code:
1SQLCA.DBParm="ConnectString ='DSN=Sales; UID=dba; PWD=sql'"