Do you use msSQL server 7? i had the same problem mwith mssql 7 and, to be more misterious, it did not happen always, but just in some cases. Anyway, what I did was that I have replaced "between" with "greater-then and less-then" logic
(R_Batch_Test_V.tDate BETWEEN...
When define an implicit recordset object by
set adRS = adcmd.execute
server will always create forward/read-only cursor
To define dyamic cursor you need to create an so-called explicit recordset object
set rs = Server.CreateObject("adodb.recordset")
rs.cursortype = 3 (dynamic cursor)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.