Setting the SQL Server Connection dialog box options

The purpose of this dialog box is to define a connection to a SQL Server database using the Managed Data Provider for SQL Server supplied by the .NET Framework 1.1 SDK.

To set the dialog box options:

1. Enter a name for the new connection.

   NOTE

   Do not use any spaces or special characters in the name.

2. Enter the connection string.

   Dreamweaver provides a string template in the Connection String text box. Replace the placeholders in the string with the requested information. For more information, see Sample OLE DB connection parameters for ASP.NET.

3. Click Test.

   Dreamweaver attempts to connect to the database. If the connection fails, double-check the connection string. If the connection still fails, check the settings for the folder Dreamweaver uses to process dynamic pages (see Specifying where dynamic pages can be processed).

4. Click OK.

   The new connection appears in the Databases panel.

Related topics

• Creating an ASP.NET database connection in Dreamweaver
• Obtaining an OLE DB provider for your database