milani_lucie
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 .Connectio n")
Kcn.ConnectionString = "server=Personal;uid=Sam;p wd=Passwor d;provider =SQLOLEDB; database=S ample"
Kcn.OPEN
set Krs = Kcn.execute("EXEC uspSample") // "uspSample" is stored procedure name
do while not Krs.EOF // Error here
loop
Thanks
I am getting that error. Here is the code:
dim Kcn, Krs
set Kcn = server.CreateObject("ADODB
Kcn.ConnectionString = "server=Personal;uid=Sam;p
Kcn.OPEN
set Krs = Kcn.execute("EXEC uspSample") // "uspSample" is stored procedure name
do while not Krs.EOF // Error here
loop
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?
be back....
OK, I just tested it and it worked fine.
Are you sure you are using the code I posted?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks