[asterisk-bugs] [Asterisk 0016668]: ms sql connections problems

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16668 
====================================================================== 
Reported By:                voipas
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   16668
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.6.0.20 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-01-21 10:22 CST
Last Modified:              2010-01-21 10:24 CST
====================================================================== 
Summary:                    ms sql connections problems
Description: 
Hello,

  In the peak (200 simultaneus calls) I started loose some data in MS SQL
(cdr records).
My previous configuration was:
[mfdb]
enabled => yes
dsn => MFDB
pooling => yes
limit => 40
username => login
password => password
pre-connect => yes
backslash_is_escape => no

`odbc show mfdb` showed me that I have used 40 connections. After
restarting asterisk and changing to these parameters:
[mfdb]
enabled => yes
dsn => MFDB
pooling => yes
limit => 200
share_connections => no
username => login
password => password
pre-connect => yes
backslash_is_escape => no


  and after my heavy testings , now I see 105 opened connections. And I
see all CDR records in database. 
 And is it possible close these connections , when I have for example 1
call and so on?

  Thanks
====================================================================== 

---------------------------------------------------------------------- 
 (0117025) seanbright (manager) - 2010-01-21 10:24
 https://issues.asterisk.org/view.php?id=16668#c117025 
---------------------------------------------------------------------- 
Are you using the FreeTDS ODBC driver? 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-01-21 10:24 seanbright     Note Added: 0117025                          
======================================================================