Connecting to an external JDBC Type 4 data source

To use a JDBC driver that is not included with ColdFusion MX 7 (such as SQLAnywhere or PostgreSQL) you must configure it and add a data source for it.

To connect to an external JDBC data source:

1. Copy the database driver .jar file to one of the following directories:
   • (server configuration only) cf_root/lib
   • (multiserver or J2EE configuration) cf_webapp_root/WEB-INF/cfusion/lib
2. Restart ColdFusion MX 7.

   For more information, see Managing ColdFusion MX 7.

   Note: In Windows, ensure that you restart all of the ColdFusion MX 7 services; these are listed in Overview of services.

3. In the ColdFusion MX Administrator, add the other JDBC Type 4 data source, selecting Other from the Driver drop-down list box.

   For more information, see the chapter on data source management in Configuring and Administering ColdFusion MX.

You can now connect to an external JDBC Type 4 data source.

View comments in LiveDocs