| View previous topic :: View next topic |
| Author |
Message |
BryantZ at zktech.com
Guest
|
 Posted: Fri Oct 16, 2015 12:46 pm Post subject: [asterisk-users] pjsip database error when using MS SQL via |
 |
|
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 |
|
| Back to top |
|
 |
mjordan at digium.com
Guest
|
| Posted: Sat Oct 17, 2015 11:23 am Post subject: [asterisk-users] pjsip database error when using MS SQL via |
|
|
On Fri, Oct 16, 2015 at 12:45 PM, Bryant Zimmerman <BryantZ@zktech.com> wrote:
| Quote: | 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 |
|
| Back to top |
|
|
|
Search
