Guide to setting up an Access database connection in Macromedia Dreamweaver MX 2004 for classic ASP pages.
- Setup your site in Dreamweaver
- Open or create a new ASP page
- 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 Access ODBC Tool in the 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. (This is not related to any password protection set using the Permission Manager in the control panel.)
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
