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

Page: 297 / 326

Connecting to the sample database (JSP) 297
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:
■
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.
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.