Adobe ColdFusion 8

Connecting to an external JDBC Type 4 data source

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

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.

    Note: In Windows, ensure that you restart all of the ColdFusion 8 services.

  3. In the ColdFusion 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.

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