Re: MDAC 2.8 - Command returning a Recordset in C++


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:ORKpuMH%23GHA.4404@xxxxxxxxxxxxxxxxxxxxxxx
Scott wrote:
Ralph,

I moved the close of the connection object until after I was done
with the recordset and that seemed to work.

This was originally a disconnected recordset with a select statement
that changed for each response message it was requesting. So I was
trying to get a little more from the SQL server by parameterizing the
select statement.

When returning a recordset via a command object is there any such
thing as a disconnected recordset?

Of course there is, but you have to set the _recordset's_
activeconnection property to nothing (null), not the command's.


LOL!

I read over that line a zillion times. I thought he was closing the
recordset. A classic case of seeing what you expect rather than what's
there.

-ralph


.

Relevant Pages

  • Re: delete records from database
    ... ' Creating Recordset Object and opening the database ... Dim rsDeleteEntry 'Holds the recordset for the record to be deleted ... 'Set an active connection to the Connection object using a DSN-less ... The best way to solve this is to use a saved parameter query. ...
    (microsoft.public.inetserver.asp.db)
  • Re: delete records from database
    ... ' Creating Recordset Object and opening the database ... Dim rsDeleteEntry 'Holds the recordset for the record to be deleted ... 'Set an active connection to the Connection object using a DSN-less ... The best way to solve this is to use a saved parameter query. ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQLs
    ... the database ... 'Set an active connection to the Connection object using ... 'Create an ADO recordset object ... 'Initialise the strSQL variable with an SQL statement to ...
    (microsoft.public.frontpage.programming)
  • Re: SQLs
    ... Microsoft FrontPage MVP ... || Web Database Development Step by Step .NET Edition ... > 'Set an active connection to the Connection object using ... > 'Create an ADO recordset object ...
    (microsoft.public.frontpage.programming)
  • Re: I am having a problem in my asp in the recorsets running at iis 6.0 and sql 2000. Sometimes it
    ... > and if I do the same sql querys using query analizer, the sql server ... maintaining your code know what each recordset contains? ... Always use an explicit connection object. ...
    (microsoft.public.inetserver.asp.general)