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

[Daniel-Constantin Mierla]

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 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
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at 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 -

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