Try doing this: Using ODBC Data Sources in ColdFusion MX
ColdFusion MX uses JDBC, not ODBC. Want to use your ODBC data sources with CFMX? You can. Here's what you need to do: 1) Create the ODBC data source (using Windows Control Panel), and 2) add a data source in ColdFusion MX Administrator of type "ODBC Socket" specifying the name of the ODBC data source. -----Original Message----- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 October 2002 6:47 AM To: CF-Talk Subject: Access Datasources Failing on MX Re-install So I did an uninstall of CFMX on my dev box - removing everything I could think of; directories, mappings, registry keys of previous versions, etc. After performing what I thought would be a clean install, I found when adding back my Access data sources, which were functioning fine before the uninstall, that somehow CF already knew the path to each datasource, but worse, all of them fail to verify with the following message: Connection verification failed for data source: (dsn name) []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. These are standard Access dbs with no extra security on them. Anyone seen this before? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
