Connector Dialog for OLEDB

Data Source

Type the name of the data source you want to access—typically a server name.

Location

Type the location of the data source you want to access—typically a database name.

Use Windows NT Integrated security

Click to use an authentication service to identify yourself.

To use this feature, your OLE DB provider must support an authentication service.

The OLE DB Provider for SQL Server is an example. You also must have permissions in the data source to use the authentication service.

Use a specific user name and password

Click to use a supplied user name and password to authenticate your logon information to the data source.

User name

Type the User ID to use for authentication when you log on to the data source.

Password

Type the password to use for authentication when you log on to the data source.

Blank password

Enables the specified provider to return a blank password in the connection string.

Allow saving password

Allows the password to be saved with the connection string. Whether the password is included in the connection string depends on the functionality of the calling application.

Note: If saved, the password is returned and saved unmasked and unencrypted.

Enter the initial catalog to use

Type in the name of the catalog (or database), or select from the drop-down list.

Select database

Use one of these methods:

• Type the database name that you want to access.

• Attach an SQL database file as a database name. Type the database name to use for the attached SQL database file.

• For SQL Server versions 6.5 and earlier, type the database file name to attach. Then type the name of the single-file database file. To browse for the file, click the button.

Test Connection

Click to attempt a connection to the specified data source. If the connection fails, ensure that the settings are correct. For example, spelling errors and case sensitivity can cause failed connections.