Setting the SQL Server Connection dialog box options

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.
  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

Getting Started with Dreamweaver
Dreamweaver Basics
Working with Dreamweaver Sites
Laying Out Pages
Adding Content to Pages
Working with Page Code
Preparing to Build Dynamic Sites
Making Pages Dynamic
Developing Applications Rapidly