|
HI
Guys in my application, the following excption is arising :
System.Web System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
I know this exception is because my application have reached the maximum connection pool size, what can be the possible reasons, and how to fix it, plzz reply ASAP,Thankx in advance.
|
|
|
|
|
The reason is most likely that you don't close the connections that you use, or don't close the data readers.
---
b { font-weight: normal; }
|
|
|
|
|
Well i have closed the connections and the data readers, what can be any other reason for it, If i increas the Max pool Size in Connection string what are its effects, plzzzzz reply ASAP,Thankx.
|
|
|
|
|
Normally you should never need to increase the pool size. I think that it is set at 100 by default, and you would need quite a lot of traffic to use that many connections.
Unless you have something like hundreds of page requests per second, your application is leaking connections somewhere.
---
b { font-weight: normal; }
|
|
|
|
|
Have you explicitly set the pool size? If yes, please check and set appropriatly.
you might like to use using(){} block for connection and datareader to use your connection and readet objects. That will take care of closing your connections accordingly.
- ashish
|
|
|
|
|
if it application window open or else close thats not cosider. i wanna every 15 min automatically update the database please give me sample coding
Dhatchinamoorthy.R
9894824838
|
|
|
|
|
You can't do that with a web page. A web page needs a request to run, it can't be scheduled.
If you are using MS SQL Server, you can use the scheduler in the database to run a stored procedure every fifteen minutes.
Otherwise you will have to write a program that either handles the scheduling itself, or is run using the windows scheduler.
---
b { font-weight: normal; }
|
|
|
|
|
thanks
i will do web page itself.could u send me sample coding
Dhatchinamoorthy.R
9894824838
|
|
|
|
|
Hi,
I am getting one error regarding viewstate when i redirect the page. in the second page i am getting the below error. i have enabled viewstate in the second page. And just i am redirecting from first page not i am doing anything in the second page even i am not placed single control. The error is given like below mentioned
"The viewstate is invalid for this page and might be corrupted. "
Thanks in advance...
Thanks and Regards
Venkat
|
|
|
|
|
When you access the Server.transfer("Pagename","true") utility in an aspx page, you will get the following error.
The View State is invalid for this page and might be corrupted
Thanks and regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|
|
Hi,
Thanks for your suggestion. But here i am not using server.transfer. I will give my code.
document.formname.method="post"
document.formname.action="secondpage path"
document.formname.submit()
that is my code. so the same error it is giving in second page
Can you please suggest me the solution
Thanks in advance
Thanks and Regards
Venkat
|
|
|
|
|
|
Hi
I know how to display an image in a web page by reading it from DB. However, I am not sure what format the image is stored in database.
I am reading it in a byte array and sending the byte array to the response stream with the content type set to gif (also tried with bmp).
The result is a blank image placholder (one shown when the image is not found).
I also tried to save it to a file and reference the file in the web page with the same result. The OS refuses to open the file as an image.
Has this something to do with specifically Access? I am using the Northwind Access DB for some learning purpose.
Any help is appreciated.
Shreekar
http://shreekarishere.blogspot.com
|
|
|
|
|
|
I'm doing a web application that connects to a reader where there are some line sof code that need to be execute under the button1.click events. Under the event, there is a DO loop where it always check whether there is any bar code scanned over the reader. If there is a barcode scanned, then the bardcode ID will be display in a listbox, else the DO loop continues to loop till the user press the Stop button.
Is there anywhere which the listbox in the page will display the barcode ID on runtime once the tag was scanned and continue to loop if user did not press the Stop button? Pelase help. Thanks in advance
|
|
|
|
|
can we do with out postback itemcommand event in Repeater control.
k.ravi sankar
|
|
|
|
|
No.
"A democracy is nothing more than mob rule, where fifty-one percent of the people may take away the rights of the other forty-nine." - Thomas Jefferson
"Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." - Benjamin Franklin
Edbert
Sydney, Australia
|
|
|
|
|
can u plz make clear,why with out postback is not possiable.
k.ravi sankar
|
|
|
|
|
if there is no postback, no event will be fired.
sAqIb
"Our scientific power has outrun our spiritual power. We have guided missiles and misguided men."
Dr. Martin Luther King Jr.
|
|
|
|
|
I am doing shopping cart,but when click add on repeater it add to the cart. Client requirement is with out Postback.Is their any alternate way for with out flickering.
k.ravi sankar
|
|
|
|
|
i am also facing same kind of problem. I am working in asp.net 2, and has used atlas too, but still there is flickering. i don't think there will be an alternate way but there must be some way to avoid flickering. Why don't we both search for it and inform each other if anyone finds it first.
regards
sAqIb
"Our scientific power has outrun our spiritual power. We have guided missiles and misguided men."
Dr. Martin Luther King Jr.
|
|
|
|
|
have u any idea about outputcache,then i have one solution.I tried,but i don't know about Outputcache.
k.ravi sankar
|
|
|
|
|
are you thinking to do caching?
sAqIb
"Our scientific power has outrun our spiritual power. We have guided missiles and misguided men."
Dr. Martin Luther King Jr.
|
|
|
|
|
yes,i did two different user controls one for items another for cart.Now i want to apply caching for items usercontrol,then we can reduse flickering.
k.ravi sankar
|
|
|
|
|
i can help u to implement caching.
sAqIb
"Our scientific power has outrun our spiritual power. We have guided missiles and misguided men."
Dr. Martin Luther King Jr.
|
|
|
|