Data provider or other service returned an E_FAIL status

[Bob S]

I've started getting this error on an asp page that has been working
fine for over a year:

==============================
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Error Type:
Microsoft Cursor Engine (0x80004005)
Data provider or other service returned an E_FAIL status.
/_ScriptLibrary/Recordset.ASP, line 125
===============================

Line 125 is:
this._count = this._rsADO.RecordCount;

Response.Buffer is set to true on this page.

I found postings where others were getting this error with
RecordCount, but no solutions.

I also found postings about ORDER BY causing problems, so I removed
that from my SQL statement, but still the problem persists.

The Access 2000 table behind the page has 1203 records. I have other
asp pages working with other (smaller--950 records) tables in the same
db no problem.

The setup: IIS 5 on W2K Pro SP4, Access 2000 tables, MDAC 2.5 SP3.

The Access form front-end for this table works fine, and there doesn't
seem to be any corrupt records in the table.

I suspect it may be one of the recent MDAC patches? Any help much
appreciated!

Bob

[Bob Barrows]

Bob S wrote:

> I've started getting this error on an asp page that has been working
> fine for over a year:
>
> ==============================
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> Error Type:
> Microsoft Cursor Engine (0x80004005)
> Data provider or other service returned an E_FAIL status.
> /_ScriptLibrary/Recordset.ASP, line 125

Sorry, I doubt you will get much help for the Interdev Recordset DTC. Most
of us write our own ADO code. I've never used any of the code in the
_ScriptLibrary.

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.

[Bob S]

[email]rws_usa@yahoo.com[/email] (Bob S) wrote in message news:<9ad3e4a5.0401061623.31ece10e@posting.google. com>...

> I've started getting this error on an asp page that has been working
> fine for over a year:
>
> ==============================
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> Error Type:
> Microsoft Cursor Engine (0x80004005)
> Data provider or other service returned an E_FAIL status.
> /_ScriptLibrary/Recordset.ASP, line 125
> ===============================
>
> Line 125 is:
> this._count = this._rsADO.RecordCount;
>
> Response.Buffer is set to true on this page.
>
> I found postings where others were getting this error with
> RecordCount, but no solutions.
>
> I also found postings about ORDER BY causing problems, so I removed
> that from my SQL statement, but still the problem persists.
>
> The Access 2000 table behind the page has 1203 records. I have other
> asp pages working with other (smaller--950 records) tables in the same
> db no problem.
>
> The setup: IIS 5 on W2K Pro SP4, Access 2000 tables, MDAC 2.5 SP3.
>
> The Access form front-end for this table works fine, and there doesn't
> seem to be any corrupt records in the table.
>
> I suspect it may be one of the recent MDAC patches? Any help much
> appreciated!
>
> Bob

A compact/repair and webserver reset fixed the problem. I didn't test
after each, so don't know if one or both were necessary.
Bob

[Bob S]

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message news:<OKAq0kS1DHA.4060@TK2MSFTNGP11.phx.gbl>...

> Bob S wrote:

> > I've started getting this error on an asp page that has been working
> > fine for over a year:
> >
> > ==============================
> > HTTP 500.100 - Internal Server Error - ASP error
> > Internet Information Services
> >
> > Error Type:
> > Microsoft Cursor Engine (0x80004005)
> > Data provider or other service returned an E_FAIL status.
> > /_ScriptLibrary/Recordset.ASP, line 125

>
> Sorry, I doubt you will get much help for the Interdev Recordset DTC. Most
> of us write our own ADO code. I've never used any of the code in the
> _ScriptLibrary.
>
> Bob Barrows

Bob, thanks for taking the time to respond. I can see from the
newsgroup that you're a busy man. It's great to have such a
knowledgeable and active MVP in this group.
Cheers
Bob S

[Chris Hohmann]

"Bob S" <rws_usa@yahoo.com> wrote in message
news:9ad3e4a5.0401061623.31ece10e@posting.google.c om...

> I've started getting this error on an asp page that has been working
> fine for over a year:
>
> ==============================
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> Error Type:
> Microsoft Cursor Engine (0x80004005)
> Data provider or other service returned an E_FAIL status.
> /_ScriptLibrary/Recordset.ASP, line 125
> ===============================
>
> Line 125 is:
> this._count = this._rsADO.RecordCount;
>
> Response.Buffer is set to true on this page.
>
> I found postings where others were getting this error with
> RecordCount, but no solutions.
>
> I also found postings about ORDER BY causing problems, so I removed
> that from my SQL statement, but still the problem persists.
>
> The Access 2000 table behind the page has 1203 records. I have other
> asp pages working with other (smaller--950 records) tables in the same
> db no problem.
>
> The setup: IIS 5 on W2K Pro SP4, Access 2000 tables, MDAC 2.5 SP3.
>
> The Access form front-end for this table works fine, and there doesn't
> seem to be any corrupt records in the table.
>
> I suspect it may be one of the recent MDAC patches? Any help much
> appreciated!
>
> Bob

Please post code. You may also want to get the latest MDAC.
[url]http://aspfaq.com/show.asp?id=2342[/url]