Aug 01 2019
We are running Windows SQL Server 2016 Enterprise on Windows Server 2016. The server has an instance with databases in Always On High Availability group. People connect to the instance mostly from MS Access and MS Excel applications and from time to time they experience the following error: ————————— Microsoft SQL Server Login ————————— Connection …
May 08 2019
I correctly configured ODBC connection on Asterisk server to MSSQL database in Always On cluster. The working configuration was as follows:
Oct 27 2017
While trying to execute ODBC function in Asterisk dialplan error is thrown: [Oct 27 14:20:21] ERROR[4601]: pbx.c:3380 ast_func_read: Function ODBC_INSERT cannot be read — Executing [XXXXXXXXX@internal:5] Set(“SIP/out-0000001a”, “ins=”) in new stack func_odbc.conf looks like this:
|
1 2 3 |
[UPDATE] dsn=asterisk writesql = UPDATE dutylist SET lastcaller ='${SQL_ESC(${ARG1})}' |
and my extensions.conf is:
|
1 |
exten=>_X.,n,Set(ins=${ODBC_UPDATE(${CALLERID(num)})}) |
All variables are correct, ODBC is also configured correctly (read from DB statements work).
