I also had problems with CF 6.1 when connecting to a local SQL DB. What I did was to define the datasource in the Windows ODBC control panel applet. Then when I set up the connection in CF I selected ODBC Socket and used the already defined ODBC setting.
You also need to make sure in SQL server that you have assigned some tables that the UN and PW. This is done using the SQL Enterprise Manager, the security selection, right click on the login that you are trying to use, and make sure the tables that want to allow that userid to access are checked. Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Christophe Maso [mailto:[EMAIL PROTECTED] Sent: Monday, October 24, 2005 3:01 PM To: SQL Subject: Trouble connection to local datasource I'm trying to set up a local dev/testing environment on my PC, using CFMX 6.1 and SQL Server 2000 (both installed on my local box). I've got the correct un and pw for CF to get into the database, but each time I try to set the DSN in CF administrator, it gives me an error saying: "Connection verification failed for data source: Localdb []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" Which sounds like it isn't a un/pw problem, but an outright refusal of SQL server to allow the CF app server any connection at all. Am I overlooking something? In CF admin, the info for the DSN is simple - data source name is localdb, name of the database in SQL is localdb, server is localhost, un is "sa", and pw has been entered correctly. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
