ASP Recordset error-Please help!

I don't see the exact cause of your problem, but here are some suggestions:

Use Server.CreateObject instead of CreateObject. Your code will run safer.

Use a forward-only, read-only recordset, and don't use MoveFirst. You don't seem to need a more resource consuming one.

Thanks for the ideas, but I am still having this problem. I am going crazy here. I'll keep trying. Thanks again.

Also:
Change this

Code:

---

cn.Provider="SQLOLEDB.1"
cn.ConnectionString="DATABASE=Helpdesk;SERVER=WEBSQL;UID=sa;PWD=;"

---

to this

Code:

---

cn.ConnectionString="Provider=SQLOLEDB;DATABASE=Helpdesk;SERVER=WEBSQL;UID=sa;PWD=;"

---

And make sure you are setting your objects to nothing at the bottom of your page.

I added your suggestions and I still get the same error. AAAARGH! This is really frustrating. I really do not want to do this project all over. Thanks for your help.