[unixODBC-support] unixODBC causing FreeTDS to crash or..?

Nick Gorham nick.gorham at easysoft.com
Tue Nov 15 17:49:08 GMT 2005


Trælnes AS wrote:

>Hello!
>
>I am running asterisk using unixODBC and FreeTDS against MSSQL. I get an
>error saying:
>
>[ODBC][9136][SQLExecute.c][354]
>                Exit:[SQL_ERROR]
>                DIAG [24000] [FreeTDS][SQL Server]Invalid cursor state
>
>I have asked the FreeTDS mailing list and they think this can be caused by
>"2 active statement on same connection". This seems to be the case since
>there are 2 statements executed according to the unixODBC log prior to the
>error.
>
>So since asterisk is using unixODBC and unixODBC is using FreeTDS I wonder
>if the problem could be in unixODBC? I mean: asterisk is probably using 1
>odbc connection (unixODBC) and trust unixODBC to handle multiple threads to
>that connection. Or what do you think?
>  
>
Its a driver thing. The TDS protocol only allows one current active 
statement. Sounds like the app is trying to use two. Its not down to the 
driver manager to manage this, and its unlikly to be related to threads.

-- 
Nick Gorham
Easysoft Limited



More information about the unixODBC-support mailing list