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


-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
 - http://conference.kamailio.com -