Register  |  Login




Advertisement

Start Your Own Q&A Site

Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.

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
Tutorials

 

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

admin

Date:: Mar 04, 2009

Time:: 11:44

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

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?

Tutorials 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 Experts

View More

Rank

Expert

Points

1.

nidhi

10279

2.

oracleofDelphi

6493

3.

rcastagna

5596

4.

LAGM

4848

5.

PeterNZ

3487

6.

gonzalo

2840

7.

Mason

2770

8.

jgivoni

2303

9.

xarcus

1820

10.

Anpanman

917

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