Re: Microsoft OLE DB Provider for SQL Server (0x80004005)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 09/16/04 

Date: Thu, 16 Sep 2004 14:26:55 -0400

I never asked: does the error occur when you connect to the server? Or when
you execute the procedure.

You can use SQL Profiler to get a little more insight into what is happening
(see Books Online)

AMills wrote:
> Bob:
>
> Here is my ASP code that is used:
>
> strSQL = "EXEC dbo.pci_Student_Certs_Monthly_Data_Load @MonthDate='" &
> strDate & "'"
> objConn.Execute(strSQL)
>
> Also: the changes that Microsoft suggested was to add this line to my
> connection string:
> OLE DB Services = -2;
>
> Thanks
> Andy
>
>
> "Bob Barrows [MVP]" wrote:
>
>> 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
>>
>> Start here: http://www.aspfaq.com/show.asp?id=2009
>> If it does not provide your answer, then show the code you are using
>> to generate this error. And detail the changes that were "suggested
>> by Microsoft" so we don't cover the sme ground.
>>
>>
>> Bob Barrows
>> --
>> 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. 

-- 
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.

Relevant Pages

  • Re: datasets and table adapters dissapear from forms randomly!
    ... of the previous questions in this newsgroup before posting yours - always a ... but this is a classic ADO newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: onClick in aspImage???
    ... >> header is my spam trap, so I don't check it very often. ... >> a quicker response by posting to the newsgroup. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Update an SQL database
    ... Please reply to the newsgroup. ... header is my spam trap, so I don't check it very often. ... a quicker response by posting to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Whats wrong with my IIF Statement?
    ... Please reply to the newsgroup. ... header is my spam trap, so I don't check it very often. ... a quicker response by posting to the newsgroup. ...
    (microsoft.public.access.queries)
  • Re: Whats wrong with my IIF Statement?
    ... Please reply to the newsgroup. ... header is my spam trap, so I don't check it very often. ... a quicker response by posting to the newsgroup. ...
    (microsoft.public.access.queries)