I ran into something similar and posted about it here. I'm a little fuzzy on the details now, but iirc when I created a DSN, then deleted it, then tried to create one with the same name again, it would always error out. Have you tried restarting the service?
-- jon mailto:[EMAIL PROTECTED] Wednesday, June 25, 2003, 2:31:53 PM, you wrote: EC> I had a previous connection to an Access DB. I got rid of it and tried to redo the same DSN and now I can not make any connections to Access DBs. Has anyone experienced this? I can connect to SQL EC> Server but not Access. EC> Eric >> -----Original Message----- >> From: Eric Creese >> Sent: Wednesday, June 25, 2003 10:28 AM >> To: '[EMAIL PROTECTED]' >> Subject: CFMX Developer Download >> Importance: High >> >> 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 EC> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
