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

Bryant Zimmerman BryantZ at zktech.com
Fri Oct 16 12:45:22 CDT 2015

 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.

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20151016/f93f79fe/attachment.html>

More information about the asterisk-users mailing list