PROBLEM WITH ADO RECORD. A STORED.PROC. WITH INSERTS.

[MARCELO SASSONE]

FIRST: SORRY FOR MY ENGLISH.

SECOND:
I WANT TO OPEN A RECORDSET THAT CALL TO STORED PROCEDURE
THAT INSERT INTO A TEMPORAL TABLE
THE SCRIPT IS like this:
Create proc xx
as
Create table #A(b int)
Insert into #A values(2)
Insert into #A values(3)
Select * from #A

and in VB I call this SP WITH THIS CODE:

'ADOCONECT IS MY CONNECTION
RSAUX.Open "XX",ADOCONECT,adOpenForwardOnly,adLockRea dOnly

AND I CAN'T USE THE RECORDSET BECAUSE IT'S CLOSE. IT'S GIVE ME THE ERROR
"The operation requested by the application is not allowed if the object is closed."
I PROVE WITH TEH OBJECT COMMAND AND ALL OF POSIBILITES THAT I kNOW.

CAN YOU HELP ME??
THANK YOU VERY MUCH

[John]

Hi Marcelo,

I think you need to post this message on the ASP forum. This one's devoted to support of ASP-db - a product which does all the work of opening recordsets and calling stored procedures, and displaying the data for you. Check it out at www.aspdb.com. Thanks and good luck,

John


------------
MARCELO SASSONE at 4/27/99 6:38:48 PM


FIRST: SORRY FOR MY ENGLISH.

SECOND:
I WANT TO OPEN A RECORDSET THAT CALL TO STORED PROCEDURE
THAT INSERT INTO A TEMPORAL TABLE
THE SCRIPT IS like this:
Create proc xx
as
Create table #A(b int)
Insert into #A values(2)
Insert into #A values(3)
Select * from #A

and in VB I call this SP WITH THIS CODE:

'ADOCONECT IS MY CONNECTION
RSAUX.Open "XX",ADOCONECT,adOpenForwardOnly,adLockRea dOnly

AND I CAN'T USE THE RECORDSET BECAUSE IT'S CLOSE. IT'S GIVE ME THE ERROR
"The operation requested by the application is not allowed if the object is closed."
I PROVE WITH TEH OBJECT COMMAND AND ALL OF POSIBILITES THAT I kNOW.

CAN YOU HELP ME??
THANK YOU VERY MUCH