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 don’t have the SDK, you can download and install it from the Sun website at http://java.sun.com/j2se/, which also installs the driver.

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 Adobe support center at www.adobe.com/go/17392.

After you install the bridge driver, you can create the database connection.