Question related to asp & Microsoft SQL Server.
I have application which is in running conditon.
which is developed in asp & MS SQL server.
Now when a i am going to access one of the page from application it will going to show me error.
The page is working just 1 hrs. before I haven't made any change to application.
when I am going to use err object to get detail about error description .
It show -"Operation is not allowed when the object is closed."
this description.
Please suggest what is actually problem?
What changes should I have to made in application?
Or it is a server side problem?
Status:
Open Jun 10, 2007 - 11:27 PM
asp, sql
3answers
Answers
Jun 11, 2007 - 12:10 PM
Sorry, your information is a bit thin! At a first look I would say the connection was closed between web page and SQL Server and the application tries to do a transaction on the closed connection. You should look at the code which accesses the database are sure that you do not do any database transactions AFTER a connection.close(). Or the other way around: first open the connection, then do the transaction, then close the connection.
The information in the exception should give you the method where the error occurs.
Hope this helps
Cheers
Peter
Jun 11, 2007 - 09:55 PM
It's help
Mar 04, 2009 - 07:44 AM
The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.
The Quomon Team
Answer this question
Share Your Own Experience & Expertise
We look to ensure that every question is answered by the best people with relevant expertise and experience, the best answers include multiple perspectives. Do you have relevant expertise or experience to contribute your answer to any of these commonly asked questions?
Add New Comment