[asterisk-users] odbc question

[Tilghman Lesher]

On Friday 22 January 2010 01:49:13 Giedrius Augys wrote:
> 2010/1/21 Tilghman Lesher wrote:
> > 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.
>
> Yes, I'm using FreeTDS. In Asterisk Console I can see 200 SET command (for
> inserting to MSSQL: Set("Local/123456789 at from-trunk-2f45;2",
> "ODBC_INSERT_RECORD()=111111,123456789")), but in MS SQL I can see only 60
> or 43 records. Maybe it's possible wait some time , if all connections are
> busy and retry again insert records?

Are you getting an error or a warning?  We cannot begin to guess at what might
be wrong without seeing more information.

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