Cel_tds wont INSERT cel in to MSSQLDB

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.

I don’t know why it’s not working but I can say that MsSQL is not a well used database with Asterisk, few (if any) use it.

Thank you very much.I will try to use MySQL and i will try to make careful and step by step connection.See if it works.Thanks a lot for response.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.