My development machine has: 
Win XP SP 2
CFMX 7 developer's edition
SQL Server 2000 SP 3a 
 
I was always get the following error while trying to connect to
datasources via cfadmin.
 
[Macromedia][SQL Server JDBC Driver]Error establishing socket.
Connection refused: connect
 
After Googling a bit there are several possible solutions on the forums
and many didn't work but one did.
(installing SQL SP3a, an SQL critical service pack, allowing TCP/IP in
SQL, XP SP2 firewall stopping connections, etc)
 
This worked: I had to make an ODBC connection in Windows then use the CF
ODBC Socket to connect to that.
So it works but not how it should.
Not an ideal solution in my opinion.
 
Did anyone have the same problem and solve it properly?
 
Allan


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:219874
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to