I've found in such instances that if I simply reopen the DSN definition in the CFMX Admin and save it/test it, it works fine the second time. Have you tried that?
I also have a pointer to info on another possible problem when trying to use Access datasources in CFMX. See my blog entry of 11/17, at http://cfmxplus.blogspot.com/2002_11_17_cfmxplus_archive.html#85685801. /charlie > -----Original Message----- > From: Eric Creese [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 25, 2003 11:28 AM > To: CF-Talk > Subject: CFMX Developer Download > > > I am running the FREE CFMX Developer on my machine. I am trying > to set up a new DSN to an MS Access Database on my machine. I am > using the default username (Box is checked) to make the > connection. However when I try to create the DNS I am getting the > following error. > > Connection verification failed for data source: baddata > []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. > > I have set up DSNs before with no issue. Any ideas? > > Eric > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
