use("ODBC");

var dsn = "rajesh_dsn";

var db_user = "avc";

var db_pass = "avc";

var db = new ODBC(dsn, db_user, db_pass);

var sql = "select sysdate from dual";

console_log("info","\nbefore connect with DB\n");

if(db.connect())

{

if(session.ready())

session.answer();

console_log("info","\n\nafter connect with DB\n");

if (db.exec(sql))

session.hangup(); //might want to say something nice instead.

else

console_log("info","\n\nconnect with DB\n");

while (db.nextRow())

{

row = db.getData();

console_log("info", "UserName: " );

}}

else

console_log("info","\n\nunable to connect with DB\n");

Best Regards,
Rajesh Bansal

On Fri, Jan 7, 2011 at 11:35 PM, Steven Ayre <steveayre@gmail.com> wrote:

Sounds like a SQL syntax error - can you show us the code that's
executing the statement that gives the error?

Specifically Oracle is complaining about not finding FROM where it
expects to in the SELECT.

-Steve

On 7 January 2011 15:15, Rajesh Bansal <bansal.rajeshkr@gmail.com> wrote:
> Hi ,
> I am getting error ORA -923 (from missing from statement) when i am tring to
> execute a sql query from Javascript file. Here i am successfully able to
> connect & execute queries with MYSQL. But in oracle connection i am getting
> this error even i can successfully make a connection with oracle. with isql
> & a program written in C i can connect and execute queries ok.
> I am using
> FreeSwitch 1.0.6
> unixOdbc 2.3.0
> Please tell me where is problem.
> Best Regards,
> Rajesh Bansal
>
>

> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users@lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>

_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org