Pjsip Database Error When Using MS SQL Via ODBC

Home » Asterisk Users » Pjsip Database Error When Using MS SQL Via ODBC
Asterisk Users 2 Comments

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.

Thanks

Bryant Zimmerman (ZK Tech Inc.)
616-855-1030 Ext. 2003

2 thoughts on - Pjsip Database Error When Using MS SQL Via ODBC

  • Bryant:

    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 error?

    Matt

    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