Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Controlling the type of recordset returned.

Author  Topic 

OwnedByTheMan
Starting Member

35 Posts

Posted - 2001-01-24 : 22:37:29
Is there a way to control or determine the nature of the recordset returned via ADO from a stored procedure?

I have an ADO recordset (instantiated via ASP if that matters) and if I populate it with an CmdText (regular SELECT), I can use ADO recordset/cursor properties such as AbsolutePage. When I use a stored procedure and populate the same recordset with the same cursor types and locktypes, the AbsolutePage property errors out.

Very confused.



   

- Advertisement -