We are using the stock IBM DB2 UDB driver that shipped with MX7. It took a DB2 network specialist to figure it out, but under the Advanced Settings in the connection string, we had to enter the locationName and noprompt attributes like this "locationName=ARMC;noprompt=true" but without the quotes and we connected to port 446. I think the locationName is the DB name, kind of like master on SQL server or the SID in Oracle. Prior to figuring that out, we used the JTOpen jdbc driver. hth mf
ps. this is on a FC7 x86 system running CFMX 7,0,0,91690 Enterprise. -----Original Message----- From: [email protected] [mailto:[email protected]]on Behalf Of Andrew Powell Sent: Thursday, May 21, 2009 2:32 PM To: [email protected] Subject: Re: [ACFUG Discuss] Connecting to iSeries DB2 I believe there are third party JDBC drivers for this. ap On May 21, 2009, at 2:27 PM, Kevin Hellriegel wrote: > Does anyone have any experience connecting to a DB2 database on an > AS400 with ColdFusion MX 7? If I use the example on livedocs: > > http://livedocs.adobe.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/js/html/wwhelp.htm?href=00001747.htm#1277913 > > I get an error: java.sql.SQLException: No suitable driver > > I'm assuming I need a different connector or maybe I am leaving a > parameter out? Any help would be greatly appreciated. > > Kevin > > > ------------------------------------------------------------- > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > ------------------------------------------------------------- > > > ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
