Error From res_odbc

Asterisk Asterisk Support
1

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 :

[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]
2

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.