Hi everyone.I am trying to get cel events in to MSSQLDB and got this problem
cel_tds.c:416 tds_error_handler: General SQL Server error: Check messages from the SQL Server (20018)
and this error goes with every app event.
My odbc.ini( /etc/odbc.ini)
[MSSQLServer]
Driver = FreeTDS
Description = MSSQL Server
Trace = No
Server = 192.168.11.13
Database = CallCenter
Port = 1433
TDS_Version = 7.0
My odbcinst.ini ( /etc/odbcinst.ini)
[FreeTDS]
Description=ODBC for SQL Server
Driver=/usr/lib64/libtdsodbc.so.0
Setup=/usr/lib64/libtdsS.so
FileUsage=1
My cel_tds.c(/etc/asterisk/cel_tds)
[global]
connection=192.168.11.13
;hostname=192.168.1.25
port=1433
dbname=CallCenter
table=cela
user=unixdata
password=unixdata
charset=BIG5
i had checked connection with isql MSSQLServer unixdata unixdata -woks fine
Main question how can i make tds cel insert apps and events.Whats wrong?. Thanks everybody.