ConnectString database parameter
Description
Specifies the parameters required to connect to an ODBC data
source. PowerBuilder uses these parameters to connect to the database.
Controls
-
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=<span>data</span>_<span>source</span>_<span>name</span>; {UID=<span>user</span>_<span>ID</span>;<br> PWD=<span>password</span>; <span>driver</span>_<span>specific</span>_<span>parameters</span>}<span></span>' |
|
Parameter |
Description |
|---|---|
|
data_source_name |
A name that identifies the data source. |
|
user_ID |
(Optional) The user ID required to connect |
|
password |
(Optional) The password required by user_ID to |
|
driver_specific_parameters |
(Optional) Any other driver-specific parameters |
Default
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 typedba,
and select the Password check box and typesql. -
Application
Type the following in code:
1SQLCA.DbParameter="ConnectString ='DSN=Sales;UID=dba; PWD=sql'"