I encountered this on my home development server (MX7.01 Developers). The fix was a workaround.
1. Set up a System DSN on the machine to the database. 2. Set up the CF DSN using ODBC Socket as the driver. thanks -r _____________________________________ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 -----Original Message----- From: Brian Yager [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 7:18 PM To: CF-Talk Subject: Re: Upgraded to MX7, SQL Server datasources no longer work Unfortunately, that did work. Here is the error I get back Connection verification failed for data source: calendar java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect Brian >Hey Brian, > >I've encountered this before, and got things working after installing >the latest SQL server update (should be available at >http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx) >- if that doesn't help, could you post the entire error message (minus >any private info)? > >Thanks, > >Joe > >On 2/28/06, Brian Yager <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233734 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
