MACROMEDIA DREAMWEAVER 8-GETTING STARTED WITH..., Getting Started

Page: 266 / 326

266 Setup for Sample ASP.NET Site
Before attempting to connect to the sample database, copy the database to
the remote computer’s hard disk. If you installed Dreamweaver to its
default location, the path on your local hard disk to the database file
(tutorial.mdb) is as follows:
■
C:\Program
Files\Macromedia\Dreamweaver 8\Tutorial_assets\cafe_townsend\data
\tutorial.mdb (Windows)
■
/Applications/Macromedia Dreamweaver 8/Tutorial_assets/
cafe_townsend/data/tutorial.mdb (Macintosh)
You can place the file in any folder on the remote computer, or you can
create a new folder for it. In either case, write down the full path to the
database file on a piece of paper.
After the database is in place, connect to it.
Creating a database connection
The final step of the setup process is to create a connection to the database.
To create a database connection in Dreamweaver:
1. Open any ASP.NET page in Dreamweaver, and then open the
Databases panel (Window > Databases).
2. Click the Plus (+) button in the Databases panel and select OLE DB
Connection from the pop-up menu.
The OLE DB Connection dialog box appears.
3.
Enter connTownsend as the connection name.
4. Click the Templates button.
The Connection String Template dialog box appears.
5. From the list of templates, select Microsoft Access 2000 (Microsoft Jet
4.0 Provider) and click OK.
Dreamweaver adds a connection string template in the OLE DB
Connection dialog box. The template contains placeholders for missing
information in the connection string.
NO
T
E
There are potential security issues if you place the database file inside the
Inetpub folder on the remote computer. It’s better to place the file in a
folder that’s not publicly accessible.