[SR-Users] UnixODBC cant insert sip_capture record on sql server

Grant Bagdasarian GB at cm.nl
Thu Feb 28 15:02:03 CET 2013


I meant the columns, not the values.
Insert into sip_capture([id],....,[authorization])
Values("1",....."auth goes here")

From: sr-users-bounces at lists.sip-router.org [mailto:sr-users-bounces at lists.sip-router.org] On Behalf Of Grant Bagdasarian
Sent: Thursday, February 28, 2013 2:59 PM
To: sr-users at lists.sip-router.org
Subject: [SR-Users] UnixODBC cant insert sip_capture record on sql server

Hello,

We are using SQL Server 2008 as our database. When the sip_capture module tries to insert a row, the following error is given:
db_unixodbc [con.c:220]: unixodbc:SQLExecDirect=42000:1:156:[FreeTDS][SQL Server]Incorrect syntax near the keyword 'authorization'.

Using Kamailio 3.3.4.

Is there a way to force brackets around the column values?

Regards,

Grant




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130228/ac35cb58/attachment.htm>


More information about the sr-users mailing list