Link to home
Start Free TrialLog in
Avatar of milani_lucie
milani_lucieFlag for United States of America

asked on

ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed. - ASP

Hi,

I am getting that error. Here is the code:

dim Kcn, Krs

set Kcn = server.CreateObject("ADODB.Connection")

Kcn.ConnectionString = "server=Personal;uid=Sam;pwd=Password;provider=SQLOLEDB;database=Sample"

Kcn.OPEN

set Krs = Kcn.execute("EXEC uspSample")  // "uspSample" is stored procedure name

do while not Krs.EOF  // Error here

loop

Thanks
SOLUTION
Avatar of sammySeltzer
sammySeltzer
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of milani_lucie

ASKER

Still, i am getting the same error. Any help ?

Thanks
ok, let me test.

be back....

OK, I just tested it and it worked fine.

Are you sure you are using the code I posted?
ASKER CERTIFIED SOLUTION
Avatar of Gary
Gary
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial