Use the Connection tab to specify how to connect to Oracle data.

This Connection tab is provider-specific and displays only the connection properties that are required by the Microsoft OLE DB Provider for Oracle.

Option Description

Server name

Type the server where the database you want to access is located.

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.

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.

Remarks

Note:
For more Data Link connection information, see the Data Link API Overview on MSDN.