28 Feb
2013
28 Feb
'13
8:58 a.m.
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
28 Feb
28 Feb
9:02 a.m.
I meant the columns, not the values.
Insert into sip_capture([id],....,[authorization])
Values("1",....."auth goes here")
From: sr-users-bounces(a)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
3 Mar
3 Mar
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 -
4324
days inactive
4327
days old
3 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Grant Bagdasarian