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:
- 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
- Restart ColdFusion.
Note: In Windows, ensure that you restart all of the ColdFusion 8 services.
- 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.