Register  |  Login



Question

Status: Open Points: 25 Time: 02:27 - Jun 11, 2007  

manohar.patil

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?

Categories:

Answer Discussion
Answer Summaries

 

Q&A System for Websites and Corporate Collaboration

Advertisement

  • Generates significant organic traffic for websites
  • Saves companies money, resources, and time

PeterNZ

Date:: Jun 11, 2007

Time:: 15:10

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

manohar.patil

Date:: Jun 12, 2007

Time:: 00:55

It's help

admin

Date:: Aug 22, 2007

Time:: 20:22

manohar.patil, did you get your question solved?

If you did then please close this question and distribute the points. If you found the solution on your own, we would be very happy if you could explain it here for the sake other users having the same problem.

If you didn't get a solution to your problem, please leave a comment here to let the experts know that you're still looking for an answer.

Thanks,
The Quomon Admin Team

Answer this Question

New User

Email:

Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

Summaries cannot be submitted until the Answer Discussion is complete.

Submit answers in the Answer Discussion area

Ask a Question

Have a new question? Ask!

You have 100 characters to use



Top asp Experts

View More

Rank

Expert

Points

1.

lclbus

250

2.

jgivoni

225

3.

PeterNZ

200

4.

redcharcoal

100

5.

Anpanman

65

6.

rcastagna

50

7.

nidhi

25

8.

multani.sarbjit

10

Become an Expert

Register today to share your knowledge with the community and be recognized and rewarded for your contributions.


Register Here




"Psst, Quomon is a great site. Pass it on."     Tell a Friend  |   Link To Us  |   Save to Delicious  |   Digg! Digg it



Language Options

English:

www.quomon.com

Español:

www.quomon.es