Installing DB2 JDBC Driver on CFMX 6.1 Standard

[chuckjody]

I want to connect to a DB2 database that resides on an AS400. I've seen
several articles on how to build a connection string but nothing on where to
get these additional drivers and how to install .jar files on the CFMX server.
I downloaded a 15 day trial for Data Direct JDBC Connector which does contain a
driver called db2.jar, but I believe the key to unlock costs hundreds of $,
maybe even as much as CFMX!!! I was under the impression that CFMX had optional
drivers available from Macromedia, but I can't find any on the Macromedia site.
Does anyone have any ideas/advice on how I can get this done without spending
an arm and a leg? All I want is to do is connect to (1) database. Please
Help!!!!

Thanks,

Chuck

[Steven Erat]

chuckjody wrote:
I was under the impression that CFMX had optional

> drivers available from Macromedia, but I can't find any on the Macromedia site.
> Does anyone have any ideas/advice on how I can get this done without spending
> an arm and a leg? All I want is to do is connect to (1) database. Please
> Help!!!!

DB2 JDBC drivers are supplied with CFMX Enterprise Edition only.

See:

CFMX 6.1
[url]http://www.macromedia.com/software/coldfusionmx61/whitepapers/pdf/6_1/cfmx61_feature_comparison_matrix.pdf[/url]

CFMX 7 (somewhat ambiguous, 'Enterprise DBs' includes DB2)
[url]http://www.macromedia.com/software/coldfusion/productinfo/product_editions/fp_frameset.html[/url]

DB2 is considered Enterprise class software. Most things Enterprise are
not free or inexpensive.


--
Steven Erat
Senior Server Support Engineer
Advanced Certified ColdFusion Developer
Red Hat Linux Certified Technician
Macromedia

[KLH]

We are using the jt400.jar. It has been awhile since our connection problems
were worked out. I think it was part of the Client Access package or we got it
from IBM's site. We are using MX6.1 Standard, Apache, & Red Hat on our
server. In the CF administrator JAVA and JVM page: The class path should be
something like: /opt/coldfusionmx/runtime/jre/lib/jt400.jar, Then to set up
a datasource use the OTHER option. Set the JDBC URL to:
jdbc:as400://yourserver.yourdomain.com/youras400lib Set the Driver Class to:
com.ibm.as400.access.AS400JDBCDriver The Driver Name is blank, then an AS400
login and password. I'm not the server administrator, just a CF developer who
helped research a solution. Good Luck KLH

[chuckjody]

Thanks very much KLH.
I'll give it a try
-CJ

[KLH]

Found this googling jt400.jar

[url]http://www.sys-con.com/coldfusion/article.cfm?id=687&count=5108&tot=3&pa ge=2[/url]

Much more informative.

KLH

[chuckjody]

Awesome!
Thanks so much!
-Chuck