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 Get the mailserver that powers this list at http://www.coolfusion.com
