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



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.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.



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: ADO memory leak version 2.82.1830.0
    ... ADO seems to memory leak in msdart.dll. ... Are you properly closing and destroying your recordset and connection ... Connection object is never closed, and i think this is ok. ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • 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)