Hi,
I experience the ASP ERROR "800A0e78 operation is not allowed when the object is closed"
1) i have checked the con.state
2)my connection string is correct
3) checked the recordset object before reference the object
4)MY SQL Query is also correct
But i still not able to find the Y its happening??
I suspect "may be when i am trying to connect to DB at that time connection might be broken----- is that correct??????????"

Mike.

hi mikedeepak
i think after closing the recordset you are calling again the recordset.

surendran
(Anything is Possible)

No surendran,
once i have closed the recordset means then again i am checking all the credentials i know this basics but i hav suspect onething i wanna confirm that thats it

One cannot say if that is correct without have a glimpse at your code. Is that correct? So, how about posting the code here?;)

Cheers!

_________________________
- Vijay G
Strive for Perfection