There is an error that occurs randomly on my webpage.... This error make IIS down until i restart it. I spend almost 500 hours trying to find what cause the error or a workaround (yes 500 hours i'm serious...ASP is the worst nightmare of my life) I'm not a beginner with ASP and i dont think it really matter to have the code as the error occurs randomly and there is no error in my code. Dont know why but sometime the open of the database cause IIS to stop and my site display Unspecified error each time i try to simply open the database.
Ex of my code to open the database :
set dbobject = Server.CreateObject("ADODB.Connection")
SqlQuery="Select * from SomeTable"
Set RS = dbobject.Execute(SqlQuery)
Any idea or clues will be REALLLLLLY appreciate....PLEASE HELP IF YOU CAN.