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.
|
||
|
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
|