How do I set up an Access database connection in Macromedia Dreamweaver MX 2004 for ASP.NET pages?

 

  1. Setup your site in Dreamweaver per this article
  2. Open or create a new ASP.NET page.
  3. Expand the Application panel and select the Databases tab.
  4. Click on the add (+) button, and select OLE DB Connection.
  5. In the OLE DB Connection window, enter a Connection name.
  6.  Choose either one of these connection strings below, and enter it in the Connection String textbox.
    If you want to use a DSN that you created using the Access ODBC Tool in the control panel, enter:
    "DSN=[DSN Name]"

    If you want to use a DSN-less connection (recommended), enter:
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[Path to Database]"
  7. Click on the Test button to test the connection. Once successful, click OK.

    You can now use the database connection in the Dreamweaver wizards when inserting datasets or query results.

    Note: Dreamweaver will upload scripts to your site to test the database connection. For security purposes, Macromedia recommends removing these connection scripts once your site has been deployed. Click on Site menu, Advanced, Remove Connection Scripts.

Was this answer helpful?

 Print this Article

Also Read

How do I set up an Access database connection in Macromedia Dreamweaver MX 2004 for classic ASP pages?

  Setup your site in Dreamweaver per this article Open or create a new ASP page....

How do I connect to my site with Macromedia Dreamweaver MX?

  Macromedia Dreamweaver 4 and Dreamweaver MX allow you to connect to remote sites using...