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]
