Tag: ODBC

MSSQL Server Error 67 and 17 SQL Server does not exist or access denied

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 …

Continue reading

odbc_log: Unable to retrieve database handle. CDR failed.

I correctly configured ODBC connection on Asterisk server to MSSQL database in Always On cluster. The working configuration was as follows:

Continue reading

Asterisk Function ODBC cannot be read

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:

and my extensions.conf is:

All variables are correct, ODBC is also configured correctly (read from DB statements work).

Continue reading