Re: How to fill a Client Side Recorset with a command (sp exec)

From: Val Mazur (group51a_at_hotmail.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 19:33:30 -0400

Hi,

To be able to open recordset on a client side using Command, you need to set
CursorLocation property of the Connection (not recordset) to adUseClient
value 

-- 
Val Mazur
Microsoft MVP
"Juan Pablo Schmiede" <jschmiede@hotmail.com> wrote in message 
news:%23Qq$UKSaEHA.1000@TK2MSFTNGP12.phx.gbl...
> I´m trying to fill a client side RecordSet with a command executing a 
> stored
> procedure but I can´t change de cursor location, I´d also tryed using 
> named
> command from a connection, but i´m having problems with the parameters.
>
> I´m trying to be able to keep de sp execution resultset after i close de
> active connection
>
> Please any help wil be usefull
>
>
> JP
>
>

Relevant Pages

  • Re: More ASP.Net Newbie Questions
    ... The Command is then what you're doing with this connection, ... In regards to your final point, making grids and controls in general do ... > Connection and Recordset objects into, like, 37 different things. ...
    (microsoft.public.dotnet.framework.aspnet)
  • ADO recordset closed, cannot read
    ... puts it into the spreadsheet using the CopyFromRecordset command. ... I was using an ADODB Recordset object but I ... I changed it to a plain ADO connection instead. ... 'Initialize parameters ...
    (microsoft.public.excel.programming)
  • Re: insert Q
    ... Use an explicit Connection object/ ... When you use a connection's Execute method, a Command object is ... Always use an explicit recordset object: ... A Connection object implements the connection to the database. ...
    (microsoft.public.inetserver.asp.db)
  • Re: adUseClient and the command object
    ... CursorLocation property of the recordset to adUseClient, ADO command will ... > rs.CacheSize = NumPerPage ...
    (microsoft.public.data.ado)
  • Re: Recordset Closed After Having Just Being Opened
    ... by 'pass the command object to a recordset as the source parameter'. ... You must set the command.ActiveConnection to an already-opened connection ...
    (microsoft.public.vb.database.ado)
Loading