Error From res_odbc

Get help with installing, upgrading and running Asterisk.

Moderators: muppetmaster, Moderator, Support

Error From res_odbc

Postby nikak27 » Tue Jan 26, 2016 8:10 am

I have connected my odbc to MSSQL server and I'm getting sip accounts and dialplan from that and I also can call between two peers but asterisk gets error :

Code: Select all
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to MSSQL [MSSQL]...
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Jan 26 16:43:16] NOTICE[32715]: res_odbc.c:1528 odbc_obj_connect: Connecting MSSQL
[Jan 26 16:43:16] NOTICE[32715]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to MSSQL [MSSQL]
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [FreeTDS][SQL Server]The invalid escape character "\\" was specified in a LIKE predicate. (89)
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to MSSQL [MSSQL]...
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Jan 26 16:43:16] NOTICE[32715]: res_odbc.c:1528 odbc_obj_connect: Connecting MSSQL
[Jan 26 16:43:16] NOTICE[32715]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to MSSQL [MSSQL]
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [FreeTDS][SQL Server]The invalid escape character "\\" was specified in a LIKE predicate. (89)
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to MSSQL [MSSQL]...
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Jan 26 16:43:16] NOTICE[32715]: res_odbc.c:1528 odbc_obj_connect: Connecting MSSQL
[Jan 26 16:43:16] NOTICE[32715]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to MSSQL [MSSQL]
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42000: [FreeTDS][SQL Server]The invalid escape character "\\" was specified in a LIKE predicate. (89)
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:661 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to MSSQL [MSSQL]...
[Jan 26 16:43:16] WARNING[32715]: res_odbc.c:765 ast_odbc_sanity_check: Connection is down attempting to reconnect...
[Jan 26 16:43:16] NOTICE[32715]: res_odbc.c:1528 odbc_obj_connect: Connecting MSSQL
[Jan 26 16:43:16] NOTICE[32715]: res_odbc.c:1567 odbc_obj_connect: res_odbc: Connected to MSSQL [MSSQL]
nikak27
Newsterisk
 
Posts: 2
Joined: Tue Jan 26, 2016 6:41 am

Re: Error From res_odbc

Postby meightee » Thu Jan 28, 2016 2:41 pm

I dont know much about the MS SQL server,more into MySQL.

But looks like me you have an error in you query as the log says.

"The invalid escape character "\\" was specified in a LIKE predicate. (89)"

Guess you have to check that.....

But I could be wrong.
meightee
Newsterisk
 
Posts: 44
Joined: Fri Aug 29, 2008 5:46 am


Return to Asterisk Support

Who is online

Users browsing this forum: MSN [Bot] and 1 guest