Check your SQL server configuration and make sure that TCP/IP access is enabled (its off by default)
Chris Peterson -----Original Message----- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 3:07 PM To: CF-Talk Subject: RE: Blob/clob issue Dave this is what I've run into with every attempt so far: Connection verification failed for data source: Faculty_Profile2 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 > If you're unable to use the DataDirect drivers that come with CF to > connect, you will likely not be able to use any other JDBC drivers to > connect, either. What error do you get when you try to set up the > connection? > > 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! > > This email has been processed by SmoothZap - www.smoothwall.net > ...com/cf_lists/unsubscribe.cfm?user=28108.19997.4 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4