[asterisk-users] odbc question

[Tilghman Lesher]

On Friday 22 January 2010 09:53:33 Giedrius Augys wrote:
> 2010/1/22 Tilghman Lesher <tlesher at digium.com>
>
> > 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.
>
>   No errors and warnings! If you need, I can make a test again.

My guess is that there's actually nothing wrong, then, and your SQL query is
not doing what you think it should be doing.

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