I recently moved my access db to sql server express and I am making the neccessary changes in the asp code.
for some reason when opening my recordset I get an error
ADODB.Recordset error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
if i copy and paste the sql straight to query analyzer it works.
it is something with teh asp connection and I think particularly when using .CursorLocation=3 which i need for paging.