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 (Oracle)
Add/Modify Connection (Microsoft SQL Server)
Add/Modify Connection (Microsoft Access)