Re: Microsoft OLE DB Provider for SQL Server (0x80004005)
From: AMills (AMills_at_discussions.microsoft.com)
Date: 09/17/04
- Next message: Anthony: "MS04-028 Registry keys of affected software"
- Previous message: Ulf Kirsten: "getting Exchange-Informations via VBScript"
- In reply to: Bob Barrows [MVP]: "Re: Microsoft OLE DB Provider for SQL Server (0x80004005)"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 17 Sep 2004 07:51:07 -0700
Bob:
that was our dilemna as well. Every other time a timeout has occured: we
have gotten a timeout error.
All that we did was add this line after setting our connection to the
database:
objConn.CommandTimeout = 240
Thanks for all your help and insight. We really appreciate the help.
Thanks
Andy
"Bob Barrows [MVP]" wrote:
> Well done, although I'm puzzled by this. Time outs usually generate timeout
> errors for me, not connection failures. Exactly what did you do to fix this?
>
> Bob Barrows
>
>
> AMills wrote:
> > Hello Guys:
> >
> > We found the problem. It was a CommandTimeOut issue. By upping the
> > timeout, the error has been fixed.
> >
> > "AMills" wrote:
> >
> >> Hello Guys:
> >>
> >> We are getting the following error and not sure why.
> >>
> >> Microsoft OLE DB Provider for SQL Server (0x80004005)
> >> [DBNETLIB][ConnectionRead (WrapperRead()).]General network error.
> >> Check your network documentation.
> >>
> >> This error is being generated from an ASP page to a SQL Server 2000
> >> database. This error ONLY occurs when running from the web-page.
> >> When we run the Stored Procedure on the database server itself:
> >> this error is not generated.
> >>
> >> When researching: Microsoft says it might be a connection pooling
> >> issue. However: this is the only stored procedure that generates
> >> this error. And when making the modifications suggested by
> >> Microsoft, we still recieve this error. The SP is not returning a
> >> recordset, and the code is not expecting one in return.
> >>
> >> Would anyone be able to tell us what is wrong and what is causing
> >> this error?
> >>
> >> Thanks
> >> Andy
>
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>
>
- Next message: Anthony: "MS04-028 Registry keys of affected software"
- Previous message: Ulf Kirsten: "getting Exchange-Informations via VBScript"
- In reply to: Bob Barrows [MVP]: "Re: Microsoft OLE DB Provider for SQL Server (0x80004005)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
