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:
- Enter a name for the new connection.
Do not use any spaces or special characters in the name.
- 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.
- 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).
- Click OK.
The new connection appears in the Databases panel.
- Creating an ASP.NET database connection in Dreamweaver
- Obtaining an OLE DB provider for your database