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

[Grant Bagdasarian]

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-boun...@lists.sip-router.org [sr-users-boun...@lists.sip-router.org] namens Daniel-Constantin Mierla [mico...@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-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