We are having problems connecting CFMX for J2EE on JRun 4.0 and connecting to a MS Access 97 (and also 2000) db. (I know, but its a legacy system they are trying to port from CF5 to CFMX, and has light db usage).
We are getting this error: ------------------------------------ Connection verification failed for data source: APCONLINE []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. Its all running on a NT 2k Pro SP3. It also had no id/pw setup on it initially. We tried to add one, but that did not help either. We have applied the JRun 4.0 SP1 and nothing for CFMX/J2EE since there are not patches. Current MDAC was applied and that had no affect. Tkx, Jim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

