> I found out I was running CFMX 6.0. I upgraded to 6.1 and > everything works fine.
If you are using ODBC with Client Access or something like that.. this connection will fail and is NOT Stable. You should use the JTOpen JDBC Type IV Driver. I have configured this several times before with CFMX First Release. Have you checked the documentation that came with the Driver? The *.pdf explains it all. 1. Make sure the *.jar file is in your CLassPath Settings under the JVM settings. 2. IN CFMX Admin, you should create an "other" datasource 3. Parameters for Connection. Driver : com.ibm.as400.access.AS400JDBCDriver Url : jdbc:as400://IPAddress_OR_NameOFMachine/DBNAME;libraries=GOBJ,..,.. Below is not right... > >JDBC URL: jdbc:as400://cnet50.careernet.state.md. > >us;DatabaseName=DLLR170 This is the most reliable connection to AS400 from CFMX. ODBC Connection hoses up ODBC Manager within CFMX. This might be resolved in CFMX 6.1..dont know. Joe Eugene > -----Original Message----- > From: James Taavon [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 3:22 PM > To: CF-Talk > Subject: CFMX and JTOpen > > > I found out I was running CFMX 6.0. I upgraded to 6.1 and > everything works fine. I used Forta's solution which was to use > Windows ODBC Manager then use ODBC Socket in CFAdmin to create > the connection. Works great! > > > >Repost: > > > >Here are my connections. > > > >JDBC URL: jdbc:as400://cnet50.careernet.state.md. > >us;DatabaseName=DLLR170 > >Driver Class: com.ibm.as400.access.AS400JDBCDriver > > > >I ALSO TRIED THESE INSTRUCTIONS, BUT NO LUCK. > > > > > >JTOpen is an open source set of java classes that you can use to > >access the AS/400 (iSeries) > > > >The following is how to make JT400 work with an AS/400 to access data > >and submit commands. > > > >Step 1: Getting the toolkit on your CFMX server. This example assumes > >that you are running IIS on a win2k server. > > > >There are two toolkits. The following link describes the difference > >between the two. The installation instructions are the same for both. > >http://www-124.ibm.com/developerworks/oss/jt400/ > > > >You can download JTOpen from: http://www-124.ibm. > >com/developerworks/downloads/index.php?group_id=29 > > > >Once you decide on the toolkit you will want to place it on the CFMX > >server in a directory called JT400 or JTOpen in the root of C:\ or > >whatever. (It makes the path shorter and easier to handle if you put > >it in the root.) > > > >It should look something like this: > > > >c:\ JT400 or c:\ JTOpen (I?m going to use JTOpen for the rest of this > >example) > > > >Next add c:\jtopen\jt400.zip to your classpath in the MX configuration > >panel > > > >Stop and restart the MX Server service. The toolkit should be ready to > >use by CFMX. > > > >Step 2: Configure a datasource. > > > >Select configure a datasource and choose "other" > > > >CF Data Source Name = myas400_jt400 (or any old name you want) > > > >JDBC URL = jdbc:as400://myas400. > >com/myas400;prompt=false;libraries=mylib > > > >The prompt=false switch is important. By default it is set to true and > >this will choke your MX service when the AS/400 attempts to prompt it > >for authentication. The libraries switch will default to *libl if left > >blank. You can access any file with it left blank but you won?t be > >able to see the files in Dreamweaver MX or Coldfusion Studio. > > > >Driver Class = com.ibm.as400.access.AS400JDBCDriver > >This is the same with both toolboxes > > > >Driver Name Not needed > > > >Username = user > >Password = password > > > >The Username and password are required to verify the datasource > >configuration. You will receive an error if you don?t provide one. You > >have a couple of options here: First, trust your configuration and > >provide a user/password within the application <CFQUERY> tag. Second, > >create a zero authority user profile to authenticate against. > > > >Description Not needed. > > > > > >For additional URL switches see: http://publib.boulder.ibm. > >com/iseries/v5r1/ic2924/info/rzahh/javadoc/JDBCProperties. > html > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
