Hello,

seems that in 4.0 that column is named 'auth'. Anyhow, you can try via modparam, setting 'authorization_column' to "[authorization]". If not, rename that column and set this modparam to the new column name.

Cheers, Daniel

On 2/28/13 3:02 PM, Grant Bagdasarian wrote:

I meant the columns, not the values.

Insert into sip_capture([id],....,[authorization])

Values("1",....."auth goes here")

*From:*sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] *On Behalf Of *Grant Bagdasarian *Sent:* Thursday, February 28, 2013 2:59 PM *To:* sr-users@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

---

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users