I have used Client Access Express V4R4 and V5R1. It works really good with ColdFusion 4.51. Setup your connection to the AS/400 and choose to use this id every time and prompt as needed. Create your datasource and put in your lib that your application will need to have access to within the ODBC setup. When you go in CF Admin you should see your ODBC data datasource. Select it and put in your id and password that you will use for the AS/400, save it. From there you should be able to verify the datasource within CF Admin.
As a word of caution - If you are running CFMX I have been having the AS/400 turn away connections under a heavy load then it gets so bad that the connection just stops working. Restarting the ODBC services clears up the connection until a heavy load hits it again. The definition of a heavy load is 40 to 80 concurrent users. I am looking into using JDBC to the AS/400. Chris -----Original Message----- From: Lee Surma [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 2:24 PM To: CF-Talk Subject: AS400 Admin ODBC Setup I'm working in a new environment that uses the Clinet Access ODBC driver that creates a connection with an AS/400. The driver is installed on the Web/ColdFusion server and I know it works because Microsoft Access can connect to it. A system DSN is set up in data sources control panel and the server is NT 4. How do I set up the ODBC data source in the ColdFusion Administrator. I hacked in a few things and it's throwing this error: Connection verification failed for data source: leesDataSource []java.sql.SQLException: No suitable driver available for leesDataSource, please check the driver setting in jrun-resources.xml, error: QGPL,tstdfile,tstdmisf The root cause was that: java.sql.SQLException: No suitable driver available for leesDataSource, please check the driver setting in jrun-resources.xml, error: QGPL,tstdfile,tstdmisf Lee Surma 612-669-1875 --------------------------------- Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, and more ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
