I am getting the following error on one of my ASP pages:
Microsoft Cursor Engine (0x80004005)
Data provider or other service returned an E_FAIL status.
I have no idea how to fix the problem, especially because the code exists on three other pages that are working fine. It happened once before and I don't remember what I did except move the cursor assignment, which didn't help because it messed up other code. Any suggestions would be greatly appreciated.
'get max number of pages
TotalPages = rstPanning.PageCount
'set absolute pages
rstPanning.AbsolutePage = CurPage
After I open the recordset, every reference to it causes the error (like the CacheSize assignment). It just doesn't make any sense because this code is identical on other pages that are working and I copied the code from an article on pagination. Do you know what this error means?