Originally posted by rnealejr
What is the statement in your code that is causing this error ? Are you using xp_sendmail ?
This is the code that is causing the problem:
'explicitly create a recordset object
set rstPanning = Server.CreateObject("ADODB.Recordset")
'set cursor location property
rstPanning.CursorLocation = adUseClient
'set cache size equal to # records/page
rstPanning.CacheSize = NUM_PER_PAGE
rstPanning.PageSize = NUM_PER_PAGE
'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?