Although JSP applications must communicate with databases through JDBC drivers, they can communicate through ODBC drivers if you have a JDBC-ODBC bridge driver. The bridge driver acts as an interpreter between your JSP application, which "speaks" JDBC, and your ODBC driver, which "speaks" ODBC. This channel of communication lets your JSP application communicate with the database.
This kind of connection offers two advantages for Windows users. First, you can use the free ODBC drivers from Microsoft. Second, you can use a DSN to simplify the task of creating the connection.
You must meet the following requirements to connect through an ODBC driver:
If you meet these requirements, you can connect through an ODBC driver. For instructions, see Creating an ODBC connection.
Make sure an ODBC driver for your database is installed on the Windows computer running the JSP application server. To find out whether an ODBC driver is installed, see Viewing the ODBC drivers installed on a Windows system. If an appropriate driver is not installed, you can download and install the Microsoft Data Access Components (MDAC) 2.5 and 2.7 packages on the computer running the JSP application server. You can download MDAC for free from the Microsoft website at http://msdn.microsoft.com/data/mdac/downloads/. These packages contain the latest ODBC drivers from Microsoft.
Install the MDAC 2.5 package before installing MDAC 2.7.
If you have an ODBC driver for your database, you can install a JDBC-ODBC driver next. For instructions, see 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.
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.
If you dont have the SDK, you can download it from the Sun website at http://java.sun.com/j2se/ 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 drivers limitations, see TechNote 17392 on the Macromedia support center at www.macromedia.com/go/17392.
After you install the bridge driver, you can create the database connection next. For instructions, see 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 (see Checking for the ODBC driver and Installing the Sun JDBC-ODBC Bridge driver).
For instructions, see the following articles on the Microsoft website:
The panel displays the connections defined for that site.
The Sun JDBC-ODBC Driver (ODBC Database) dialog box appears.
Do not use any spaces or special characters in the name.
[odbc dsn]placeholder in the URL box with the DSN you defined in step 1.
The URL box should look like this:
If you dont need a user name or password, leave the boxes blank. For example, if your DSN is called Acme and you dont need a user name or password to access the database, enter the following parameter values:
Macintosh users can ignore this step because all database connections use the application server.
Dreamweaver attempts to connect to the database. If the connection fails, double-check the DSN and the other connection parameters. If the connection still fails, check the settings for the folder Dreamweaver uses to process dynamic pages (see Specifying where dynamic pages can be processed).
The new connection appears in the Databases panel.