Macromedia dreamweaver 8-using dreamweaver User Manual

Connecting to a database

635

For example, if your server is called Aristotle, the database port is 1521, and you defined a 
database SID called 

patients

 on that server, you would enter the following parameter values 

in Dreamweaver: 

Connecting to a database

This section describes how to connect to a database when developing a JSP application 
in Dreamweaver.

The section assumes a JSP application server is running on a local or remote computer. For 
more information, see 

.

Before you can connect to a database, you must obtain a JDBC driver for your database. For 
more information, see 

. 

After you install the database driver, you can connect to the database through it. For 
instructions, see 

Obtaining a JDBC driver for your database

Make sure you have a JDBC driver for your database before you try to create a database 
connection. Some common JDBC drivers include the Oracle Thin JDBC driver, the Oracle 
Java Driver, and the i-net JDBC drivers for Microsoft SQL Server.

Database system vendors such as Oracle often include drivers with their systems. You can also 
purchase drivers from third-party vendors. For example, you can obtain a JDBC driver for 
Microsoft SQL Server from i-net software at 

Sun also provides a searchable database of JDBC drivers and their vendors on its website at 

.

Once you have a JDBC driver for your database, you can create a database connection.