Dreamweaver

Create an ASP.NET database connection in Dreamweaver

After obtaining an OLE DB provider for your database, use it to create a database connection in Dreamweaver.

Another option is to use the Microsoft Data Link Properties dialog box to help you create the connection.

  1. Open an ASP.NET page in Dreamweaver, and then open the Databases panel (Window > Databases).
  2. Click the Plus (+) button on the panel, and select OLE DB Connection or SQL Server Connection from the menu.
    Note: Select SQL Server Connection only if you want to connect to a Microsoft SQL Server database.
  3. Enter a name for the new connection, without spaces or special characters, and enter the connection string.
    Note: If you need help with an OLE DB connection string, click Templates to open the Connection String Template dialog box, select your OLE DB provider, and click OK.
  4. Replace the placeholders in the string with the requested information, click Test, and then click OK.