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-boun...@lists.sip-router.org [mailto:sr-users-boun...@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 -

_______________________________________________
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

Reply via email to