<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.EmailStyle17
{font-family:"Calibri","sans-serif";
color:windowtext}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:11pt; color:black">FS "pings " the db to keep the connection open. The statement is "select 1" by default, which is invalid for ORACLE.<br>
There is no config file to set this, you have to edit the file src/switch_odbc.c (iirc) and recompile.<br>
<br>
Sent from my Android phone using TouchDown (www.nitrodesk.com)<br>
<br>
<span style="color:black">-----Original Message----- <br>
<b>From:</b> Ira Tessler [ira@connectmevoice.com]<br>
<b>Received:</b> Mittwoch, 01 Feb. 2012, 20:44<br>
<b>To:</b> FreeSWITCH-users@lists.freeswitch.org [FreeSWITCH-users@lists.freeswitch.org]<br>
<b>Subject:</b> [Freeswitch-users] Using Oracle as a database<br>
<br>
</span></span>
<div>
<div class="WordSection1">
<p class="MsoNormal">I have odbc set up for Oracle on my FS Linux box. I can connect to Oracle using isql and run queies. I am trying to configure Freeswitch to using the database but when I start up Freeswitch I get the following error message:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">2012-02-01 14:29:07.056793 [CRIT] switch_odbc.c:280 The sql server is not responding for DSN dbnj [STATE: HY000 CODE 923 ERROR: [Oracle][ODBC][Ora]ORA-00923: FROM keyword not found where expected</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Anyone have any ideas ?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Ira Tessler</p>
<p class="MsoNormal">ConnectMe</p>
<p class="MsoNormal">(732) 490-9007 x2</p>
<p class="MsoNormal"><a href="http://www.connectmevoice.com/">www.connectmevoice.com</a></p>
<p class="MsoNormal"> </p>
</div>
</div>
</body>
</html>