June 5, 2011 at 8:27 pm
ODBC problems connecting to SQL Server 2008
Can ping both ways, no firewall issues, NETCAT can spawn a shell using port 1433.
ODBC driver version 2.575.1132.00
Both machines XP pro , SP 2 and 3
I get (in part) Connection failed , SQL state 01000 server error 10061, then SQL state 08001 error 17
On the server side I have TCP/IP enabled, and I’ve rebooted the machine a number of times since I did that.
June 10, 2011 at 1:58 pm
please post the connections string you are using. If using a DSN make sure you have not specified a protocol other than TCP/IP (if that's what you want).
You should be using SQL Native Client.
The probability of survival is inversely proportional to the angle of arrival.
June 11, 2011 at 12:19 pm
You should post your connection strings as requested.
Not sure of the details but ...
http://blogs.msdn.com/b/spike/archive/2008/11/07/sql-server-error-10060-sql-server-error-10061.aspx
http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/27684811-1a59-4273-b7ed-3cc990b4f20a
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=70972
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply