Hello,

Alright, I will try that. I temporarily fixed it by editting the .c file and enclosing the parameter with brackets. It works, but not a good approach.

Thanks!

Regards,

Grant

Van: sr-users-bounces@lists.sip-router.org [sr-users-bounces@lists.sip-router.org] namens Daniel-Constantin Mierla [miconda@gmail.com]
Verzonden: zondag 3 maart 2013 18:03
Aan: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List
Onderwerp: Re: [SR-Users] UnixODBC cant insert sip_capture record on sql server

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 -