Some time ago, Robert Everland had a problem with creating ColdFusion datasources for SQLServer, getting an error "Connection refused". There were lots of suggestions but the archives dont seem to say what was the actual solution. Does anyone know what the solution was? I've been through the sugestions given at the time and anything else I can think of and the problem persists.
Specifically, the error message says: [quote] Connection verification failed for data source: afpwebworks 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 [/quote] I've reinstalled SQLServer and CFMX7, I've tried using (local) as the server name, also 127.0.0.1 also localhost also WDEV01 (the computer's name and the instance name of SQLServer) and none work. In fact using (local) as the servername, gives a different error, the problem then is "unknown host: (local) To create a datasource, I have to create it in the control panel, then use the ODBC driver. It works ok , and its fast enough for a dev machine - it will only have one user at a time in any case - but i'd like to know what's wrong with the setup of SQLServer or CFMX if i can find it out. I tried writing to Robert, but his email address at the time is no longer working. Anyone know what's wrong here? -- Cheers Mike Kear Windsor, NSW, Australia Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205196 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
