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

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. 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)