Contents > Installing and Using ColdFusion MX > Configuring Your System > Connecting to an external JDBC Type 4 data source

Connecting to an external JDBC Type 4 data source

ColdFusion MX includes JDBC Type 4 database drivers from DataDirect and MySQL, JDBC Type 3 database drivers from DataDirect and SQL Link, and a JDBC Type 2 driver from Jadazoom. (JDBC is an Application Programming Interface (API) for Java programs to access data.)

To use a JDBC driver that is not included with ColdFusion MX (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 file to a directory other than the cf_root directory.
2. In the ColdFusion MX Administrator, open the Java and JVM Settings page.
3. In the Class Path text box, enter the directory that contains the driver file and click Submit Changes.

   Note: In the J2EE configuration, update the classpath using your J2EE server-specific method.

4. Restart ColdFusion MX.

   For more information, see Managing ColdFusion MX.

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

5. 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.

Contents > Installing and Using ColdFusion MX > Configuring Your System > Connecting to an external JDBC Type 4 data source

ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Comments

Add Comment

deckerd26354 said on Nov 1, 2003 at 10:48 PM :

I don't want to reinstall the whole coldfusion package; I just need to reinstall the ODBC services. Is there a separate install for that?

ngra said on Sep 27, 2004 at 9:07 AM :

I need to make a connectin to JDBC driver for dbase, anybody can help me, please!!!

jrunrandy said on Sep 28, 2004 at 4:31 PM :

Configure an ODBC data source for the dBase databaese.

Then, use the Administrator to define an ODBC Socket data source. Go to http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/dataso14.htm#wp1238919 for more information.

RSS feed | Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/config26.htm

Add Comment