[OpenSER-Users] Error when connect to Oracle via ODBC.

[Martin.Gruber1 at infineon.com]

Hi,
 
what version of OpenSER do you use. Seems that something in the source
is not running well. Check out the newest version first.
If it is not the case let me know!
 
regards 
 
Martin

________________________________

From: users-bounces at openser.org [mailto:users-bounces at openser.org] On
Behalf Of Tung Tran
Sent: Wednesday, October 03, 2007 7:18 AM
To: users at openser.org
Subject: [OpenSER-Users] Error when connect to Oracle via ODBC.


 
Hi all,
 
I am trying to connect Openser with Oracle via odbc. So far I can
connect sucessfully to Oracle DB via unixODBC module, I can register and
make call,
However I got this error from Openser debug that I dont know it may
effect to Openser operation 
 
 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator
 
 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator
 
 1(9499) db_raw_query: Error while submitting query
 1(9499) ERROR:usrloc:get_all_db_ucontacts: raw_query failed
 1(9499) unixodbc:SQLExecDirect, rv=100. Query= delete from location
where expires<to_date('2007-10-0307:53:20','YYYY-MM-DD HH24:MI:SS') AND
expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')
 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,
socket, cflags from location where expires > now() and cflags & 64 = 64
 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator
 
 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator
 
 1(9499) db_raw_query: Error while submitting query
 1(9499) ERROR:usrloc:get_all_db_ucontacts: raw_query failed
 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,
socket, cflags from location where expires > now() and cflags & 64 = 64
 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator
 
 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator
 
 1(9499) db_raw_query: Error while submitting query
 1(9499) ERROR:usrloc:get_all_db_ucontacts: raw_query failed
 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,
socket, cflags from location where expires > now() and cflags & 64 = 64
 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator
 
 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator
 
 
Should anyone sucess customize Openser to work smoothly with Oracle?
please help.
 
Thanks and regards
Tung
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20071003/5c0949b5/attachment.htm