[Freeswitch-users] Using Oracle as a database

[Gerald Weber]

FS "pings " the db to keep the connection open. The statement is "select 1" by default, which is invalid for ORACLE.
There is no config file to set this, you have to edit the file src/switch_odbc.c (iirc) and recompile.

Sent from my Android phone using TouchDown (www.nitrodesk.com)

-----Original Message-----
From: Ira Tessler [ira at connectmevoice.com]
Received: Mittwoch, 01 Feb. 2012, 20:44
To: FreeSWITCH-users at lists.freeswitch.org [FreeSWITCH-users at lists.freeswitch.org]
Subject: [Freeswitch-users] Using Oracle as a database

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:

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

Anyone have any ideas ?

Thanks,

Ira Tessler
ConnectMe
(732) 490-9007 x2
www.connectmevoice.com<http://www.connectmevoice.com/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120201/598a1e67/attachment.html