Brian, before you go doing that, reread my email on this. I encountered this problem, and this solution, which I found months ago, worked.
1. Set up a System DSN on the machine to the database. 2. Set up the CF DSN using ODBC Socket as the driver. As long as the system DSN connects successfully to the database, this will work. thanks -r _____________________________________ Rob Barthle Contractor - Sr. Software Developer [EMAIL PROTECTED] 202-245-6484 -----Original Message----- From: Brian Yager [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 01, 2006 3:49 PM To: CF-Talk Subject: Re: Upgraded to MX7, SQL Server datasources no longer work I've got both Named Pipes and TCP/IP enabled. The DB server is on the same machine as the CF Server. So Firewalls wouldn't be the problem. But just to make sure, I disabled Windows Firewall and it sitll didn't work. I think I am going to uninstall CF 7 and reinstall it to see if that makes a differenc. I am just clueless right now. >> 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 > >Are you sure you configured the server to listen on TCP/IP? Run the Server >Network Utility, and make sure that TCP/IP is enabled; I suspect that you >only have Named Pipes enabled. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ > >Fig Leaf Software provides the highest caliber vendor-authorized >instruction at our training centers in Washington DC, Atlanta, >Chicago, Baltimore, Northern Virginia, or on-site at your location. >Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233874 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
