Basic connection options
The Connection tab includes the following basic connection
options that you must supply to access your data:
Profile Name
The name of your database profile.
Data Source
Select the name of the ODBC data source that this profile accesses.
The Data Source drop-down list includes the names of all ODBC data sources
currently defined in your ODBC initialization file. The name you specify
displays as the DSN value in the ConnectString DBParm parameter. (You
can check the Preview
tab (PowerBuilder only) to see the ConnectString DBParm syntax.)
User ID
The user name required to connect to the data source. To override
the user ID setting in your ODBC data source definition, select
the User ID check box (its default setting) and specify the name
you want to use to access the data source in the User ID textbox.
The name you specify displays as the UID value in the ConnectString
DBParm parameter. (You can check the Preview
tab (PowerBuilder only) to
see the ConnectString DBParm syntax.)
If instead you want PowerBuilder or InfoMaker to obtain the
user ID from your ODBC data source definition (assuming your data
source definition requires a user ID), clear the User ID check box.
This disables the User ID textbox. If the User ID check box is cleared
and no user ID is specified in your data source definition, PowerBuilder
or InfoMaker prompts you for the user ID when you connect to the
data source.
Password
The password for the specified user ID. The password you type displays
with asterisks (*). To override the password setting in
your ODBC data source definition, select the Password check box
(its default setting) and specify the password you want to use to
access the data source in the Password textbox. The name you specify
displays as the PWD value in the ConnectString DBParm parameter.
(You can check the Preview
tab (PowerBuilder only) to see the ConnectString DBParm syntax.)
If instead you want PowerBuilder or InfoMaker to obtain the
password from your ODBC data source definition (assuming your data
source definition requires a password), clear the Password check
box. This disables the Password textbox. If the Password check box
is cleared and no password is specified in your data source definition,
PowerBuilder or InfoMaker prompts you for the password when you
connect to the data source.
Security considerations
When you specify the password in an ODBC data source definition,
it displays in your ODBC initialization or file. This may be a security
risk. Instead, you can specify the password at execution time as
the PWD value in the ConnectString DBParm parameter or in response
to a prompt. This way, the password does not display in your ODBC
initialization or preferences file.
Driver-Specific Parameters
(Optional) Any other parameters that your ODBC driver uses
to connect to the data source. By default, the PowerBuilder or InfoMaker
connection uses the driver-specific parameters specified in your ODBC
data source definition. To override these, you can specify one or
more parameters in the Driver-Specific Parameters textbox, separating
multiple parameters with semicolons. The parameters you specify
display in the ConnectString DBParm parameter. (You can check thePreview
tab (PowerBuilder only) to
see the ConnectString DBParm syntax.)
For example, CDB is a driver-specific parameter for the PB
MERANT Btrieve ODBC driver. You can specify CDB = 1 in
this box to create a new Scalable SQL data dictionary if one does
not already exist.
For information about the driver-specific parameters
that your ODBC driver supports, see your driver documentation.
Prompt for Database Information
(Optional) Select this check box to be prompted for connection
information when creating or selecting a profile to access a database.
Generate Trace
(Optional) Select this check box to start the Database Trace tool
in order to trace your connection.