Hi Steve,<div><br></div><div>I am using following sample code.</div><div><br></div><div><div>use(&quot;ODBC&quot;);</div><div><br></div><div>var dsn     = &quot;rajesh_dsn&quot;;</div><div>var db_user = &quot;avc&quot;;</div>
<div>var db_pass = &quot;avc&quot;;</div><div>var db      = new ODBC(dsn, db_user, db_pass);</div><div>var sql = &quot;select sysdate  from dual&quot;;</div><div><br></div><div>console_log(&quot;info&quot;,&quot;\nbefore connect with DB\n&quot;);</div>
<div><br></div><div>if(db.connect())</div><div>{</div><div>if(session.ready())</div><div> session.answer();</div><div>console_log(&quot;info&quot;,&quot;\n\nafter connect with DB\n&quot;);</div><div><br></div><div>if (db.exec(sql))</div>
<div>        session.hangup(); //might want to say something nice instead.</div><div>else</div><div>        console_log(&quot;info&quot;,&quot;\n\nconnect with DB\n&quot;);</div><div>while (db.nextRow())</div><div>{</div>
<div>  row = db.getData();</div><div>  console_log(&quot;info&quot;, &quot;UserName: &quot; );</div><div>}}</div><div>else</div><div><br></div><div>console_log(&quot;info&quot;,&quot;\n\nunable to connect with DB\n&quot;);</div>
<div><br></div>Best Regards,<br>Rajesh Bansal<br><br>
<br><br><div class="gmail_quote">On Fri, Jan 7, 2011 at 11:35 PM, Steven Ayre <span dir="ltr">&lt;<a href="mailto:steveayre@gmail.com">steveayre@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Sounds like a SQL syntax error - can you show us the code that&#39;s<br>
executing the statement that gives the error?<br>
<br>
Specifically Oracle is complaining about not finding FROM where it<br>
expects to in the SELECT.<br>
<br>
-Steve<br>
<div><div></div><div class="h5"><br>
<br>
On 7 January 2011 15:15, Rajesh Bansal &lt;<a href="mailto:bansal.rajeshkr@gmail.com">bansal.rajeshkr@gmail.com</a>&gt; wrote:<br>
&gt; Hi ,<br>
&gt; I am getting error ORA -923 (from missing from statement) when i am tring to<br>
&gt; execute a sql query from Javascript file. Here i am successfully able to<br>
&gt; connect &amp; execute queries with MYSQL. But in oracle connection i am getting<br>
&gt; this error even i can successfully make a connection with oracle. with isql<br>
&gt; &amp; a program written in C i can connect and execute queries ok.<br>
&gt; I am using<br>
&gt; FreeSwitch 1.0.6<br>
&gt; unixOdbc    2.3.0<br>
&gt; Please tell me where is problem.<br>
&gt; Best Regards,<br>
&gt; Rajesh Bansal<br>
&gt;<br>
&gt;<br>
</div></div>&gt; _______________________________________________<br>
&gt; FreeSWITCH-users mailing list<br>
&gt; <a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
&gt; <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
&gt; UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
&gt; <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
&gt;<br>
&gt;<br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br></div>