Share via


Advanced Properties

The Advanced Properties dialog box allows you to specify properties for the connection using the data source and provider selected in the Choose/Change Data Source dialog box. The content of this dialog box changes depending on which provider is selected in the Choose/Change Data Source dialog box. The Advanced Properties dialog box appears when you click the Advanced button on the Add Connection, Modify Connection, or New Database Reference dialog boxes.

Note

At the bottom of the dialog box, the corresponding connection string is displayed in a box that allows you to select and copy it for your own use.

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.

In addition, the specific settings that appear depend on the type of database to which you connect. For more information about advanced properties for SQL Server, see the following page on the Microsoft Web site: SqlConnectionStringBuilder Properties.

See Also

Tasks

How to: Connect to a Database from Server Explorer

Reference

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)