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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy