Does Standard come with the IBM DB2 UDB driver? On Thu, May 21, 2009 at 2:43 PM, Fennell, Mark P. <[email protected]> wrote: > 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?falogin.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 -------------------------------------------------------------
