RecordCount property in SQL Server

[JScannell]

I am receiving a -1 for my recordCount property in a query that is opened like:

Set objConns = Server.CreateObject ("ADODB.Connection" )
set objResps = Server.CreateObject ("ADODB.recordset" )

objResps.LockType = adLockOptimistic
objResps.CursorType = adOpenKeyset

objResps.Open thisQuery, objConns

I can't do a moveLast or a movePrevious. Everything I have read says that the Cursor type and Lock type determines this. As to what I have read my query should work, but it doesn't. I have tried adOpenDynamic

Any ideas?

Thanks in advance,
Jerry

Jerry Scannell

 

[ChrisHirst]

You could read the FAQs for this forum

and faq333-4615 specifically

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[JScannell]

Turns out that making it a Client Cursor worked. Why did I have to do this? This code has worked in the past with another SQL Server database without any problems. Now it fails unless I make it a client server.

Thanks,
Jerry

Jerry Scannell

 

[monksnake]

This is the server-side ASP that I use and it does allow for movePrevious and moveLast, you can give it a try if you would like.

var adOpenStatic     = 3;
var adLockOptimistic = 3;
var adUseClient      = 3;
var adModeReadWrite  = 3;
objResps.ActiveConnection = oConn;
objResps.CursorType = adOpenStatic;
objResps.LockType = adLockOptimistic;
objResps.CursorLocation = adUseClient;

<.