SQL Server Performance Forum – Threads Archive

80004005 error

I have sql server 2000 on a separate machine from iis and when trying to insert data to fields with data types varchar(8000) using stored procedures it gives me this error
Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
any suggestions PLZ

---

Can you reach the sql server from the web server? Try and ping the sql server from the web server and vice versa. If it does not work try ping by IP address instead of name. If IP works but not name then you have a problem with name resolution. If none works then check that there is no router or firewall between the servers that are blocking port 1433. /Argyle

---

Generally some sort of problem finding the DSN.
Could be lost in the global.asa file, or perhaps this is not a SYSTEM DSN. Satya SKJ

---

Try to use ip address in your connection string instead of server name.
But if you can’t even ping that sql from your iis it defenetly fire wall ask your adminstrator to add entry to fire wall

---

Try connecting using a DSN-Less connection like this:<br /><br />&lt;%<br />strconn = "Driver={SQL Server};SERVER=MY_SERVER;UID=MY_ID<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />WD=MY_PWD;DATABASE=MY_DB"<br />set Conn = server.createobject("adodb.connection")<br />Conn.open strconn<br />%&gt; <br /><br /><br /><br />———-<br />T Kelley<br />MS, MCDBA, OCA, CIW<br /><br />

---

Thank you guys
the problem was that the sql server is behind the firewall and there are limitations on the backet size

---

]]>