Are you "hard coding" connection information into your queries? Is there a conflict there?
Eg: <cfquery name="ReviewView" datasource="#Request.DataSourceName#" username="mydbusername" password="mydbpassword"> Preferably let that info stay in the ColdFusion datasource, eg: <cfquery name="ReviewView" datasource="#Request.DataSourceName#"> No username or password hardcoded into the application. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robin Hilliard Sent: Friday, 3 December 2004 9:39 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Connection verification failed for data source Tim Donovan wrote: > Thanks Robin....but no luck...I get this a similar error > > Connection verification failed for data source: Test3 > []java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for > JDBC]Error establishing socket. > The root cause was that: java.sql.SQLException: [Microsoft][SQLServer > 2000 Driver for JDBC]Error establishing socket. Well you've eliminated the driver at least. Go with the accounts/permissions lead - good luck! Robin http://www.rocketboots.com.au --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
