Lee Surma wrote: > 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.
Preferably, you don't. Use native JDBC. > 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 Your driver is not installed correctly. Is the classpath correct? Right driver class? Etc. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
