Setting up the database (server on remote 

computer)

This section applies only if your web server is running on a remote 

computer. If your web server is running on the same computer as 

Dreamweaver, skip to 

 Creating a database connection  on page 298

.

Before attempting to connect to the sample database, perform the 

following tasks on the remote computer running your web server: copy the 

sample database to the computer's hard disk, create a DSN on the 

computer that points to the database, and install the Sun JDBC ODBC 

Bridge driver on the computer.

To set up the sample database on the remote computer: 

1.

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:

I

C:\Program 

Files\Macromedia\Dreamweaver 8\Tutorial_assets\cafe_townsend\

data\tutorial.mdb (Windows)

I

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

NO

There are potential security issues if you place the database file inside the 

TE

Inetpub folder on the remote computer. It's better to place the file in a 

folder that's not publicly accessible.

Connecting to the sample database (JSP) 297