Using the Connection Properties dialog box you can set the required and optional properties of a Connection object. The properties are divided between three tabs: General, Authentication, and Miscellaneous.
Note The Connection Properties dialog box is only used by Visual InterDev.
On the Authentication tab, specify a user name and password for the connection, and designate how and where this information is stored.
Design-time Authentication Information
This frame contains information used in the connection string. These values help build the connection string that the Connection object uses to connect to a data source.
Note The keywords used for the user name and password depend on the data source selected on the General tab, as described in User Name and Password.
The properties in this frame are for both design time and run time unless Run-time Authentication Information is provided, in which case the properties set in this frame apply only to design time.
User Name (Design-time Authentication Information frame)
The name of a user to authenticate. If the data source is an ODBC DSN, the keyword is UID; if the data source is an OLE DB file or a connection string, the keyword is User ID. If saved, this is used at design time.
Password (Design-time Authentication Information frame)
The password which authenticates the user. If the data source is an ODBC DSN, the keyword is PWD; if the data source is an OLE DB file or a connection string, the keyword is Password. If saved, this is used at design time.
Prompt Behavior (Design-time Authentication Information frame)
Specifies the prompting behavior by the Connection object, such as when to request logon information.
For Visual Basic, this option specifies both design- and run-time behavior. For Microsoft® Visual InterDev™, the selected prompt behavior is for design time, while at run time the prompt behavior is always Never, and this option is disabled.
Save Design-time Authentication (Design-time Authentication Information frame)
When selected, the authentication information is saved, causing the specified logon data to persist at design and run time. However, if Run-time Authentication Information is provided, the properties set in the Design Authentication Information frame apply only to design time.
Run-time Authentication Information
This frame contains information used in the connection string at run time only.
The properties in this frame help build the connection string that the Connection object uses to connect to a data source at run time. The properties are either stored in the actual class, or are persisted in the build executable file or DLL.
User Name (Run-time Authentication Information frame)
The name of a user to authenticate. If the data source is an ODBC DSN, the keyword is UID; if the data source is an OLE DB file or a connection string, the keyword is User ID. If saved, this is used at run time.
Password (Run-time Authentication Information frame)
The password which authenticates the user. If the data source is an ODBC DSN, the keyword is PWD; if the data source is an OLE DB file or a connection string, the keyword is Password. If saved, this is used at run time.
Prompt Behavior (Run-time Authentication Information frame)
Specifies the prompting behavior by the Connection object, such as when to request logon information.
This option is used for Visual Basic only. When using Visual InterDev, the run-time prompt behavior is always Never, and this option is disabled.
Save Run-time Authentication (Run-time Authentication Information frame)
When selected, the authentication information is saved, causing the specified logon data to persist at run time.