Macromedia dreamweaver 8-using dreamweaver User Manual
638
Chapter 27: Database Connections for JSP Developers
Installing the Sun JDBC-ODBC Bridge driver
To connect through an ODBC driver, you must install the Sun JDBC-ODBC Bridge driver
on the Windows computer running the JSP application server. The driver comes with the Sun
Java 2 SDK, Standard Edition, for Windows.
on the Windows computer running the JSP application server. The driver comes with the Sun
Java 2 SDK, Standard Edition, for Windows.
To find out if you already have the Java 2 SDK with the driver, check your hard disk for any of
the following folders: jdk1.2, jdk1.3, or j2sdk1.4.
the following folders: jdk1.2, jdk1.3, or j2sdk1.4.
and install it. The driver installs automatically when you install the SDK.
Although it is adequate for development use with lower-end database systems such as
Microsoft Access, the Sun JDBC-ODBC Bridge driver is not intended for production use.
For example, it lets only one JSP page connect to the database at a time (it does not support
concurrent use by multiple threads). For more information on the driver’s limitations, see
TechNote 17392 on the Macromedia support center at
Microsoft Access, the Sun JDBC-ODBC Bridge driver is not intended for production use.
For example, it lets only one JSP page connect to the database at a time (it does not support
concurrent use by multiple threads). For more information on the driver’s limitations, see
TechNote 17392 on the Macromedia support center at
.
After you install the bridge driver, you can create the database connection next.
Creating an ODBC connection
Before connecting through an ODBC driver, make sure the appropriate ODBC driver and
the Sun JDBC-ODBC Bridge driver are installed on the Windows computer running the JSP
application server .
the Sun JDBC-ODBC Bridge driver are installed on the Windows computer running the JSP
application server .
To connect through an ODBC driver in JSP:
1.
Define a DSN on the Windows system hosting your application server.
For instructions, see the following articles on the Microsoft website:
■
Windows 2000 users, see Microsoft Knowledge Base Article 300596 at
■
2.
Open a JSP page in Dreamweaver, then open the Databases panel (Window > Databases).
The panel displays the connections defined for that site.
3.
Click the Plus (+) button on the panel and select Sun JDBC-ODBC Driver (ODBC
Database) from the pop-up menu.
Database) from the pop-up menu.
The Sun JDBC-ODBC Driver (ODBC Database) dialog box appears.