Add/Modify Connection Dialog Box (General)

This dialog box allows you to create and modify database connections. There are four ways to access this dialog box:

  • From the Tools menu select Connect to Database.

  • Right-click the Data Connections node in Server Explorer and click Add Connection.

  • From the Database menu select Modify Connection.

  • Right-click the data connection you want to modify in Server Explorer and click Modify Connection.

Note

This topic also covers the New Database Reference dialog box.

Note

This topic does not cover the elements within the body of the dialog box, so if you need more specific information, click in the center of the dialog box and then press F1. If you return to this topic, it may be that the provider you chose in the Choose/Change Data Source does not supply help for this dialog box.

Note

The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.

  • Test Connection
    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 (Oracle)

Add/Modify Connection (Microsoft SQL Server)

Add/Modify Connection (Microsoft Access)

Add/Modify Connection (OLE DB)

Add/Modify Connection (Microsoft SQL Server Database File)