Data provider or other service returned an E_FAIL status

Posted on 2006-04-03
Medium Priority
Last Modified: 2012-06-27
I am getting the following error when running a page against  a SQL Server database. When I run the page against my local copy of SQL Server, there is no problem.
Error Type:
Microsoft Cursor Engine (0x80004005)
Data provider or other service returned an E_FAIL status.
/tsac/tsacsearch/POSearchResult.asp, line 168
Here is the code snippet that may be the cause of the problem:

Set rec = Server.CreateObject("ADODB.Recordset")
rec.CursorLocation = 3 '=adUseClient
rec.PageSize = intPageSize

rec.Open cmd,,3,3

'rec.Open cmd

intPageCount = rec.PageCount (Line 168)

Reccount = rec.RecordCount

Question by:cityside
  • 2
  • 2
LVL 25

Assisted Solution

kevp75 earned 180 total points
ID: 16361414
Make sure to have the latest MDAC installed on the server and clients.  http://msdn.microsoft.com/data/mdac/downloads/default.aspx

this error can also be caused by a NULL value in the WHERE statement of your query
LVL 52

Accepted Solution

Carl Tawn earned 195 total points
ID: 16361428
This guy had the same problem, maybe it will be of use to you:

LVL 25

Expert Comment

ID: 16446206
why the C grade?

Author Comment

ID: 16476652
why the C grade? Because it didn't solve the problem.
I  gave you the points anyway. What more do you want?

Author Comment

ID: 16476728
Fair enough.
I'll remember that in future.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question