-
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.
-
Darn It!
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.
-
Still...:mad:
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.