Connecting to an external JDBC Type 4 data source



To use a JDBC driver that is not included with ColdFusion (such as SQLAnywhere) configure the JDBC driver 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 9 services.

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

      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.