- 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.
