This seems to be the only thing that works. Thanks much! Brian
> 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:234023 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
