Are you using the hostname of the SQL Server in your connection? (ie: sql.mysite.com)
If so you may want to try switching to the IP address instead, I've seen this when using the hostname, switching to the IP should remedy the problem. Thanks, Joshua Miller Head Programmer / IT Manager Garrison Enterprises Inc. www.garrisonenterprises.net [EMAIL PROTECTED] (704) 569-9044 ext. 254 ************************************************************************ ************* Any views expressed in this message are those of the individual sender, except where the sender states them to be the views of Garrison Enterprises Inc. This e-mail is intended only for the individual or entity to which it is addressed and contains information that is private and confidential. If you are not the intended recipient you are hereby notified that any dissemination, distribution or copying is strictly prohibited. If you have received this e-mail in error please delete it immediately and advise us by return e-mail to [EMAIL PROTECTED] ************************************************************************ ************* -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:51 PM To: CF-Talk Subject: RE: Database Connection just goin for the obvious here, have you verified the user/pass combo...is it SA and blank password, or did you set it up to be something? did someone change it, is it set up for mixed mode auth? (integrated windows/sql server) can you make a system dsn from the odbc control panel icon? ...tony -----Original Message----- From: Double Down, Inc. [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:48 PM To: CF-Talk Subject: Database Connection I get the following error when I try to go to any cold fusion page in my site. The error reads: Error Executing Database Query. SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. I have checked the SQL server and it is running fine. When I go into the CF Admin to verify the datasource I get an error that reads: Connection verification failed for data source: 2x []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. Can anyone please help me with this? I need to get this problem solved ASAP TIA DDINC ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
