Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Error -[TCP/IP Sockets]ConnectionWrite (send())

Author  Topic 

chih
Posting Yak Master

154 Posts

Posted - 2007-08-21 : 19:43:10
Since we change the web server to window 2003, we occasionally receive the message
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())

We use ASP and ODBC to access sql 2005. I have specified to use TCP/IP and port 1433 in ODBC.

Any idea to solve it?

Thank you in advance.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-21 : 19:51:33
I would consider change ODBC to OLEDB/ADO.
Are you using ASP.Net? Then replace ODBC with ADO.Net.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

chih
Posting Yak Master

154 Posts

Posted - 2007-08-21 : 20:08:19
we use ASP not asp .NET

quote:
Originally posted by Peso

I would consider change ODBC to OLEDB/ADO.
Are you using ASP.Net? Then replace ODBC with ADO.Net.



E 12?5'05.25"
N 56?4'39.16"

Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-21 : 22:15:02
Tried connect to sql with ip address?
Go to Top of Page
   

- Advertisement -