Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 8 of 8
  1. #1
    Regular Coder
    Join Date
    Nov 2002
    Location
    Manchester, UK
    Posts
    533
    Thanks
    4
    Thanked 1 Time in 1 Post

    whats this error: E_FAIL status??

    I just got this error message on one of the ASP pages on my site.. any ideas??

    Code:
    Microsoft Cursor Engine error '80004005' 
    
    Data provider or other service returned an E_FAIL status. 
    
    /features.asp, line 65
    Line 65 is: "Page_Count = RS.PageCount"

    It works on another page I have used, just for some reason, not this one!

    Thanks....

  • #2
    Senior Coder Morgoth's Avatar
    Join Date
    Jun 2002
    Location
    Ontario, Canada Remaining Brain Cells: 6
    Posts
    1,402
    Thanks
    2
    Thanked 1 Time in 1 Post
    It would help more if you posted the code.
    A single line tells us nothing.

    Usually when you have something that has more then one line of code in it and you get an error, the error is probibly on one line of code that the error report doesn't tell you, because it's just showing you the executed line, we need to know what your executing to debug it.

    Know what I mean?

  • #3
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    it is a cursor engine error, maybe the cursor action you want is not supported by the cursortype you defined for the recorset you created
    I am the luckiest man in the world

  • #4
    Regular Coder
    Join Date
    Nov 2002
    Location
    Manchester, UK
    Posts
    533
    Thanks
    4
    Thanked 1 Time in 1 Post
    ok, sorry bout that guys!!
    here's some more of the code....

    Code:
    If Request("pageno")="" Then
    Current_Page = 1
    Else
    Current_Page = CInt(Request("Pageno")) 'the CInt function converts the value to an integer.
    End If
    
    Page_Size = 5
    
    Set MyConn = Server.CreateObject("ADODB.Connection")
    Set RS = Server.CreateObject("ADODB.RecordSet")
    MyConn.Open strConnect
    
    RS.CursorLocation = adUseClient
    RS.PageSize = Page_Size
    
    SQL = "SELECT features.featureID, features.body, features.hits, features.status, members.memberID, members.username, features.memberID, features.category, features.title, features.date_submitted, features.public FROM members INNER JOIN features ON members.memberID = features.memberID WHERE features.public = 'Y';"
    
    RS.Open SQL, MyConn, adOpenStatic, adLockReadOnly, adCmdText
    
    'this page_count is the part which the browser says is the problem
    Page_Count = RS.PageCount
    		
    If 1 > Current_Page Then Current_Page = 1
    If Current_Page > Page_Count Then Current_Page = Page_Count
    
    if RS.EOF then
    'no records
    records = 0
    current_page = 1
    else
    RS.AbsolutePage = Current_Page
    Records = RS.RecordCount
    end if
    what's annoying is I have the exact same code for another page (this one is "features" and the other is "news") and that works perfectly!!

    Thanks again.....

  • #5
    Supreme Master coder! glenngv's Avatar
    Join Date
    Jun 2002
    Location
    Philippines
    Posts
    11,068
    Thanks
    0
    Thanked 256 Times in 252 Posts
    did you include the file adovbs.inc in the page?
    Glenn
    ____________________________________

    My Blog
    Tower of Hanoi Android app (FREE!)
    Tower of Hanoi Leaderboard
    Samegame Facebook App
    vBulletin Plugins
    ____________________________________

  • #6
    Regular Coder
    Join Date
    Nov 2002
    Location
    Manchester, UK
    Posts
    533
    Thanks
    4
    Thanked 1 Time in 1 Post
    yeah, the adovbs.inc is included.. I have narrowed the problem down to something wrong with the table.... I just dont know what!

    I used the code in my post above but I changed the SQL statement to the most basic one to see if it was that...

    "SELECT * from features" ... it still had the same error. Then I changed the table from features to "news" and it worked fine. Thats all I changed!! and the error vanished!!

    So any ideas what might be wrong with the table?

    It seems to work ok with the admin panel.. ie: I can get records to display and update... but I dont seem to be able to use the pageCount request........

    Thanks for the help guys!


  • #7
    Regular Coder
    Join Date
    Nov 2002
    Location
    Manchester, UK
    Posts
    533
    Thanks
    4
    Thanked 1 Time in 1 Post
    oh, just one more thing (in the words of the great columbo ;-) )...

    it seems to work on my local server (IIS) ... just not on the W2K host server!!

    how confusing!!

  • #8
    Regular Coder
    Join Date
    Nov 2002
    Location
    Manchester, UK
    Posts
    533
    Thanks
    4
    Thanked 1 Time in 1 Post
    I found the error....!!

    It was a field in the DB... when I downloaded the current DB.. there was a field contents called "#ERROR" and when I clicked it... it said "Another user is trying to update this record" something wrong with the "Jet Engine"?!

    So I deleted it and re-uploaded the DB... now it works fine!

    What might have caused that error?!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •