Add/Modify Connection (Oracle)

The Add Connection dialog box for Oracle allows you specify settings, such as database file name and passwords, for this connection. This dialog box is available when Oracle Database is selected under Data Source in the Choose/Change Data Source dialog box or when <unspecified> is selected under Data Source and .NET Framework Provider for Oracle is selected under Data Provider in the Choose/Change Data Source dialog box. To use a different provider, click the Change button and select a different data source or provider in the Change Data Source dialog box.

• Data Source
  Shows the data source and provider chosen in the Data Source dialog box.

• Change button
  Brings up the Change Data Source dialog box where you can change the data source or provider.

• Server name
  Shows the name of the server for this connection. To choose a different server, select one from the drop-down list or type the server name into the text box.

• User name
  Provides a text box in which to enter a User ID. When you open this connection, the logon dialog box will require that you enter this User ID to access the database. The database administrator must first grant permission for you to access the database in order for the connection to succeed.

• Password
  Provides a text box in which to enter a password. When you open this connection, the logon dialog box will require that you enter this password to access the database. The database administrator must first grant permission for you to access the database in order for the connection to succeed.

• Save my password
  Saves and encrypts your password so that you do not need to enter a password each time you open the connection.

• Advanced button
  Displays the Advanced Properties dialog box, where you can specify or view settings for the connection. The content of this tab changes depending on which provider you selected in the Data Source dialog box. For more information about Oracle-specific connection settings, see Connecting to Oracle Database on the Oracle web site.

• Test connection button
  Tests the connection without closing the dialog box so you can make adjustments to the settings if the connection does not succeed.

• OK button
  Commits the connection settings.

See Also

Tasks

How to: Connect to a Database from Server Explorer

Reference

Advanced Properties

Choose/Change Data Source Dialog Box

Add/Modify Connection (ODBC)

Add/Modify Connection (Microsoft SQL Server)

Add/Modify Connection (Microsoft Access)

Add/Modify Connection (OLE DB)

Add/Modify Connection (Microsoft SQL Server Database File)

Change History