Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Closing out database connections. Timeouts

Reply
Thread Tools

Closing out database connections. Timeouts

 
 
Do
Guest
Posts: n/a
 
      12-09-2003
Hi,

Is it better to

objConn = Nothing
or
objConn.Close.

I'm starting to get an error message that

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.
What am I doing wrong?

Thanks,

Do



 
Reply With Quote
 
 
 
 
Frank Oquendo
Guest
Posts: n/a
 
      12-09-2003
Do wrote:
> Hi,
>
> Is it better to
>
> objConn = Nothing
> or
> objConn.Close.


objConn.Close(). Database connections do not close themseleves upon
going out scope.

> What am I doing wrong?


There are other issues to consider such as network latency and server
load. But start by closing all your connections as soon as you're done
with them and take it from there.

--
There are 10 kinds of people. Those who understand binary and those who
don't.

http://code.acadx.com
(Pull the pin to reply)


 
Reply With Quote
 
 
 
 
srinivas moorthy
Guest
Posts: n/a
 
      12-09-2003
Hi,
Timeout Problem arises if you have any query which
consumes more resources and more time in execution. Just
cross check with the Query which you are using in SQL
QUERY Analyzer.

For the Command Object there is a property called TimeOut
which u can set an integer value for query execution time
period.

Thanks
srinivas moorthy
>-----Original Message-----
>Hi,
>
> Is it better to
>
>objConn = Nothing
>or
>objConn.Close.
>
>I'm starting to get an error message that
>
>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.
>What am I doing wrong?
>
>Thanks,
>
>Do
>
>
>
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Database Database Database scott93727@gmail.com Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase scott93727@gmail.com Computer Information 0 09-26-2012 09:40 AM
Closing the doors 15 minutes before closing. doofus Computer Support 12 06-11-2005 08:20 AM
forms authentication timeouts and session timeouts =?Utf-8?B?SmFzb24=?= ASP .Net 0 06-22-2004 09:24 AM
Session-Timeouts and Idle-Timeouts on AS5300 and AS5800 Matt Cisco 1 02-17-2004 06:59 PM



Advertisments