<html dir="ltr"><head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<meta name="GENERATOR" content="MSHTML 9.00.8112.16464">
<style title="owaParaStyle"><!--P {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
--></style>
</head>
<body bgcolor="#ffffff" ocsi="x">
<div dir="ltr"><font color="#000000" size="2" face="Tahoma">Hello,</font></div>
<div dir="ltr"><font size="2" face="tahoma"></font> </div>
<div dir="ltr"><font size="2" face="tahoma">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.</font></div>
<div dir="ltr"><font size="2" face="tahoma"></font> </div>
<div dir="ltr"><font size="2" face="tahoma">Thanks!</font></div>
<div dir="ltr"><font size="2" face="Tahoma"></font> </div>
<div dir="ltr"><font size="2" face="tahoma">Regards,</font></div>
<div dir="ltr"><font size="2" face="tahoma"></font> </div>
<div dir="ltr"><font size="2" face="tahoma">Grant</font></div>
<div style="DIRECTION: ltr" id="divRpF588441">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>Van:</b> sr-users-bounces@lists.sip-router.org [sr-users-bounces@lists.sip-router.org] namens Daniel-Constantin Mierla [miconda@gmail.com]<br>
<b>Verzonden:</b> zondag 3 maart 2013 18:03<br>
<b>Aan:</b> SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List<br>
<b>Onderwerp:</b> Re: [SR-Users] UnixODBC cant insert sip_capture record on sql server<br>
</font><br>
</div>
<div></div>
<div>Hello,<br>
<br>
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.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 2/28/13 3:02 PM, Grant Bagdasarian wrote:<br>
</div>
<blockquote type="cite"><style>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page WordSection1 {margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
LI.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
DIV.MsoNormal {
MARGIN: 0in 0in 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext
}
SPAN.EmailStyle18 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: #1f497d
}
.MsoChpDefault {
FONT-SIZE: 10pt
}
DIV.WordSection1 {
}
</style>
<div class="WordSection1">
<p class="MsoNormal"><span style="COLOR: #1f497d">I meant the columns, not the values.
</span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d">Insert into sip_capture([id],….,[authorization])</span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d">Values(“1”,…..”auth goes here”)</span></p>
<p class="MsoNormal"><span style="COLOR: #1f497d"></span> </p>
<div>
<div style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<p class="MsoNormal"><b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">From:</span></b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">
<a class="moz-txt-link-abbreviated" href="mailto:sr-users-bounces@lists.sip-router.org">
sr-users-bounces@lists.sip-router.org</a> [<a class="moz-txt-link-freetext" href="mailto:sr-users-bounces@lists.sip-router.org">mailto:sr-users-bounces@lists.sip-router.org</a>]
<b>On Behalf Of </b>Grant Bagdasarian<br>
<b>Sent:</b> Thursday, February 28, 2013 2:59 PM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">
sr-users@lists.sip-router.org</a><br>
<b>Subject:</b> [SR-Users] UnixODBC cant insert sip_capture record on sql server</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hello,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">We are using SQL Server 2008 as our database. When the sip_capture module tries to insert a row, the following error is given:</p>
<p class="MsoNormal">db_unixodbc [con.c:220]: unixodbc:SQLExecDirect=42000:1:156:[FreeTDS][SQL Server]Incorrect syntax near the keyword 'authorization'.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Using Kamailio 3.3.4. </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Is there a way to force brackets around the column values?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Regards,</p>
<p class="MsoNormal"><br>
Grant</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset> <br>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com" target="_blank">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, April 16-17, 2013, Berlin
- <a class="moz-txt-link-freetext" href="http://conference.kamailio.com" target="_blank">http://conference.kamailio.com</a> -</pre>
</div>
</body>
</html>