asterisk users - Jan 2010 - odbc question

Hello,

   I want to know what is timeout for MS SQL connection? My config is:

[mydb]
enabled => yes
dsn => MYDB
pooling => yes
limit => 200
share_connections => no
username => login
password => password
pre-connect => yes
backslash_is_escape => no
  In the peak , I can see :
ODBC DSN Settings
-----------------
  Name:   mydb
  DSN:    MYDB
  Pooled: Yes
  Limit:  200
  Connections in use: 93

Is it possible to free idle connections? When limit was 40, I had lost part
of data. My asterisk version is 1.6.0.20 .

Thanks

-- 
Pagarbiai  / Best Regards,
Giedrius
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100121/4f6a9dad/attachment.htm

On Thursday 21 January 2010 09:51:13 Giedrius Augys
wrote:
> Is it possible to free idle connections? When limit was 40, I had lost part
> of data. My asterisk version is 1.6.0.20 .
We intentionally do not, since the maximum number of connections is always
the maximum concurrent number of queries, and there's a significant penalty
in establishing a connection.

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org