Hi Joe, Found it! It's among 500+ files residing in the doc folder. I missed that one when i search there the last time.
Those guys managing the system ain't going to upgrade the VR. They are still sticking to V4R4. If the latest JTopen might point to some older JAR files, I might want to try JTOpen 3.3 on Monday. Would that be a good idea? Thanks. Anthony ----- Original Message ----- From: "Joe Eugene" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 11, 2003 3:00 AM Subject: Re: [CFCDev] CFMX 6.1 W2K connecting to DB2 AS400 > Anthony, > > > More to configure than the above? Btw, I couldn't find the pdf document > that > > you had mentioned. > > I am not sure where you downloaded the Driver... the driver comes in 18 MB > Zip file and > includes HTML and a RZAHH.PDF File Documentation. > > http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2002-12-22+21%3A29%3A10.834939R&S_TACT=&S_CMP=&s= > > JDBC URL : "jdbc:as400://systemName/defaultSchema;listOfProperties" > > The JDBC Driver is a very new release, this means you have to be current on > you VR's, > otherwise the JAR file itself might be pointing to some older classes. > > Joe Eugene > > ----- Original Message ----- > From: "Anthony" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, October 10, 2003 1:02 PM > Subject: Re: [CFCDev] CFMX 6.1 W2K connecting to DB2 AS400 > > > > Hi Joe, > > > > hmm .. guess that I had missed out the configuration part. I did exactly > > what Hasan mentioned earlier. > > > > 1)Copied the JT400.jar file (JDBC driver) from lib folder unzipped from > > jtopen_4_1.zip (downloaded from IBM) > > 2)And place it in the lib directory under CFusionMX folder. > > (C:\CFusionMX\lib) > > 3)In the CFMX administrator create a new datasource of type OTHER. > > 4)use the following parameters : > > -JDBC URL: jdbc:as400://123.45.67.89;libraries=ABC,DEF (or) > > -JDBC URL: jdbc:as400://123.45.67.89/RST (configured for some of the > > other datasources) > > -Driver Class: com.ibm.as400.access.AS400JDBCDriver > > > > More to configure than the above? Btw, I couldn't find the pdf document > that > > you had mentioned. I saw lots of HTML documents but couldnt' find anything > > on configuration (am confused with all those documents). > > > > When you say configuration, does it mean adding more connection properties > > to the JDBC url? > > -JDBC URL: jdbc:as400://123.45.67.89;libraries=ABC,DEF;{list of other > > properties} > > > > Appreciate all your help. > > > > Thanks > > > > Anthony > > ----- Original Message ----- > > From: "Joe Eugene" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Saturday, October 11, 2003 12:01 AM > > Subject: Re: [CFCDev] CFMX 6.1 W2K connecting to DB2 AS400 > > > > > > > > > > Anthony, > > > > > > I have tested JTOpen JDBC Type IV Driver against Client Access ODBC and > > > configured both > > > on CF 5.0 and CFMX. > > > > > > "JDBC TYPE IV(JTOpen) WAS MUCH FASTER AND RELIABLE THAN ODBC(Client > > Access) > > > " > > > > > > You probably have something wrong in your JDBC Configuration. > > > Do you have the same values for JDBC (Libraries) as in Client Access > > > Configuration? > > > > > > Check the *.pdf documentation you got with JTOpen Driver. This details > on > > > configuration. > > > > > > Joe Eugene > > > > > > > > > > > > ----- Original Message ----- > > > From: "Anthony" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Friday, October 10, 2003 11:38 AM > > > Subject: Re: [CFCDev] CFMX 6.1 W2K connecting to DB2 AS400 > > > > > > > > > > Need help again. I'ld like to hear your opinion on this one. > > > > > > > > I have the following 2 servers connecting to a single database IBM > > > DB2/AS400 > > > > V4R4 > > > > > > > > (1) > > > > - Pentium Zeon 2.8Ghz Server > > > > -1GB RAM > > > > - Win2K Server > > > > - CFMX 6.1 Standard Edition > > > > - connected to AS400 using JTOpen 4.1 (JDBC) - (supposedly Type IV > isn't > > > > it?) > > > > > > > > (2) > > > > - Dual-Pentium III processor 1.3GHz > > > > - 1GB RAM > > > > - Win2K server > > > > - CF 5.0 Enterprise Edition > > > > - connected to AS400 using ODBC client (ODBC) > > > > > > > > Both running the SAME CF application previously built on CF5. On the > > > > contrary, server (2) executes faster than server (1). These pages > > contain > > > > lots of queries and it rendered almost more than twice the speed than > > the > > > > server running CFMX. Hmm .. does that mean that Red Sky isn't fast > > enough > > > or > > > > JDBC just isn't right?? > > > > > > > > TIA > > > > > > > > Anthony > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Anthony" <[EMAIL PROTECTED]> > > > > To: <[EMAIL PROTECTED]> > > > > Sent: Friday, October 10, 2003 12:39 AM > > > > Subject: Re: [CFCDev] CFMX 6.1 W2K connecting to DB2 AS400 > > > > > > > > > > > > > Hi Michael, > > > > > > > > > > I'm not familiar with AS 400. Would it be possible to upgrade the > > > database > > > > > to a later version like V4R5 or later? > > > > > > > > > > Thanks! > > > > > > > > > > Anthony > > > > > > > > > > ----- Original Message ----- > > > > > From: "Dawson, Michael" <[EMAIL PROTECTED]> > > > > > To: <[EMAIL PROTECTED]> > > > > > Sent: Friday, October 10, 2003 12:12 AM > > > > > Subject: RE: [CFCDev] CFMX 6.1 W2K connecting to DB2 AS400 > > > > > > > > > > > > > > > This is how I do it. The only diff is I'm on v5r1. > > > > > > > > > > I got the drives from here: > > > > > > > http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=expastb > > > > > jm3 > > > > > > > > > > In the CF Admin you will need to enter the path to the classes in > the > > > > > Java and JVM page: > > > > > Enter Class Path c:\as400jdbc > > > > > > > > > > These are the steps to configure the datasource in CFMX 6.1: > > > > > Data Source Name "<Your DSN Here>" > > > > > Driver "other" > > > > > Click Add > > > > > JDBC URL "jdbc:as400://<your as400 server name here>" > > > > > Driver Class "com.ibm.as400.access.AS400JDBCDriver" > > > > > Driver Name "<any sort of comment goes here>" > > > > > Username "<as400 user account goes here>" > > > > > Password "<as400 password goes here>" > > > > > Click Submit and verify > > > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > From: Anthony [mailto:[EMAIL PROTECTED] > > > > > Sent: Thursday, October 09, 2003 11:06 AM > > > > > To: [EMAIL PROTECTED] > > > > > Subject: [CFCDev] CFMX 6.1 W2K connecting to DB2 AS400 > > > > > > > > > > > > > > > Hi all, > > > > > > > > > > Need help! I read blog entries about using JTOpen (by IBM) to > connect > > to > > > > > DB2 in AS/400. Need help on how to go about doing it. > > > > > > > > > > What I have: > > > > > 1) CFMX 6.1 Standard edition installed on Win2K SP4 > > > > > 2) DB2 on AS/400 -V4R4M0 > > > > > > > > > > Questions: > > > > > 1) is OS/400 the same as AS/400? > > > > > 2) Do i install JTOpen for Java on both Win2K and AS/400? Which > > > > > installation, i'm quite confused over this. > > > > > 3) Examples on values to use when entering the JDBC URL, Driver > Class > > > > > and Driver Name in CF admin ( i assume choosing 'others' option in > the > > > > > JDBC > > > > > list.) > > > > > > > > > > Any other better way to connect to AS/400 using JDBC is also > > > > > appreciated. > > > > > > > > > > TIA, > > > > > > > > > > Anthony > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email > > to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' > > in the message of the email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported > > by Mindtool, Corporation (www.mindtool.com). > > > > An archive of the CFCDev list is available at > www.mail-archive.com/[EMAIL PROTECTED] > > ---------------------------------------------------------- > You are subscribed to cfcdev. To unsubscribe, send an email > to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' > in the message of the email. > > CFCDev is run by CFCZone (www.cfczone.org) and supported > by Mindtool, Corporation (www.mindtool.com). > > An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
