2.

Make sure the Microsoft Access Driver, version 4.0 or higher, is 

installed on the remote computer.

To find out whether the driver is already installed, see 

 Viewing the 

ODBC drivers installed on a Windows system 

 in Using Dreamweaver. 

If the driver is not installed, download and install the Microsoft Data 

Access Components (MDAC) 2.5 and 2.7 packages on the remote 

computer. You can download MDAC for free from the Microsoft 

website at 

http://msdn.microsoft.com/data/mdac/downloads/

. These 

packages contain the latest Microsoft drivers, including the Microsoft 

Access Driver.

NO

Install MDAC 2.5 before installing MDAC 2.7.

TE

3.

Set up a DSN called CafeTownsend pointing to the sample database on 

the remote computer. 

For instructions, see the following articles on the Microsoft website:

I

If the remote computer runs Windows 2000, see Article 300596 at 

http://support.microsoft.com/default.aspx?scid=kb;en us;300596

.

I

If the remote computer runs Windows XP, see Article 305599 at 

http://support.microsoft.com/default.aspx?scid=kb;en us;305599

.

4.

Make sure the Sun JDBC ODBC Bridge driver is installed on the 

remote computer. 

You will use this driver along with the DSN to create a connection to 

the database. For instructions, see 

 Installing the bridge driver  

on page 296

.

After the database, DSN, and bridge driver are in place, create a database 

connection in Dreamweaver.

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 JSP page in Dreamweaver, and then open the Databases panel 

(Window > Databases).

298 Setup for Sample JSP Site