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. |
Note For more Data Link connection information, see the Data Link API Reference.