[asterisk-users] pjsip database error when using MS SQL via ODBC

Matthew Jordan mjordan at digium.com
Sat Oct 17 11:22:56 CDT 2015

On Fri, Oct 16, 2015 at 12:45 PM, Bryant Zimmerman <BryantZ at zktech.com> wrote:
>  I have a project that is requiring the use of MS SQL from asterisk. I get
> an error when the pjsip contact tries to update the contact table.
> [Oct 15 21:34:55] WARNING[3033]: res_odbc.c:649
> ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 22018:
> [FreeTDS][SQL Server]Conversion failed when converting the varchar value
> '3.000000' to data type int. (101)
> The datatype in MySQL is integer and in MS SQL is integer. What could be the
> cause of this? Is it likely some kind of FeeTDS conversion issue?  If I
> change the MS SQL type to double the error goes away, but I am unsure of the
> long term issues associated with this.


There are two columns in the ps_contacts table that currently are
defined with an Integer type - 'qualify_timeout' and
'qualify_frequency'. Which one is currently giving the conversion


Matthew Jordan
Digium, Inc. | Director of Technology
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at: http://digium.com & http://asterisk.org

More information about the asterisk-users mailing list