On Fri, Oct 16, 2015 at 12:45 PM, Bryant Zimmerman <[email protected]> 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. >
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 -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
