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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
