Calling all u IT gurus out there....

Results 1 to 3 of 3

Thread: Calling all u IT gurus out there....

  1. #1
    Join Date
    Dec 1969

    Default Calling all u IT gurus out there....

    hey ppl<BR>tell me something...if it is possible to open more than one recordsets thru a single connection object, y is my code giving the error as &#039;The application requested an operation on an object with a reference to a closed or invalid Connection object. &#039; ?????

  2. #2
    Darren Neimke Guest

    Default Yes

    It is possible to return more than one Recordset in at a time depending on whether or not your provider is capable of implementing it. The SQLOLEDB and (I think) Microsoft.Jet.OLEDB.4.0 providers are capable of returning more than one resultset from a data retrieval operation.<BR><BR>To move from one resultset to the next is similar to navigating through each row of a single resultset however you simply call the NextRecordset method of the ADO recordset object, such as:<BR><BR> ObjRst.NextRecordset<BR><BR>HTH<BR><BR>Darren Neimke<BR>[ ]

  3. #3
    Join Date
    Dec 1969

    Default May be you have closed the Connection

    and set it to nothing and then trying to open the next recordset, see the error please, thats what it says, did you check ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts