Knowledgebase

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

 

1. Setup your site in Dreamweaver per this article
2. Open or create a new ASP page.
3. Expand the Application panel and select the Databases tab.

   To use a DSN-less connection (recommended):

   4a. Click on the add (+) button and select Custom Connection String
   5a. In the Custom Connection String window, enter a Connection name.
   6a. Enter the following in the Connection string textbox:

   "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[Path to Database]"

   7a. Select 'Using Driver on Testing Server'
   8a. Click on the Test button to test the connection. Once successful, click OK.

   To use a DSN that you created using the HELM control panel:

   4b. Click on the add (+) button and select Data Source Name (DSN).
   5b. Enter a connection name.
   6b. In the DSN textbox, enter the DSN you created in the control panel.
   7b. If you set a database password or user accounts within the Access database, enter the credentials in the User Name and Password textboxes.
   8b. Select 'Using DSN on Testing Server'.
   9b. 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 recordsets 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.

 

Also Read