3 Mar
2013
3 Mar
'13
12:03 p.m.
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(a)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(a)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 -