SQL Server Performance

80004005 error

Discussion in 'General DBA Questions' started by muthaffar, Jan 29, 2003.

  1. muthaffar New Member

    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
  2. Argyle New Member

    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
  3. satya Moderator

    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
  4. NewDBA New Member

    quote:Originally posted by muthaffar

    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

    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
  5. tkelley New Member

    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 />
  6. muthaffar New Member

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

Share This Page