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

[Martin.Gruber1 at infineon.com]

Hi,
 
please send me the structure of your location table.
 
regards
 
martin

________________________________

From: Tung Tran [mailto:tr.tung at gmail.com] 
Sent: Wednesday, October 03, 2007 8:55 AM
To: Gruber Martin (IFKL IT OS NV)
Cc: users at openser.org
Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC.


Dear Martin,
 
I am using Openser 1.2.2 and the odbc lib is libsqora.so.10.1
I also follow the guide on web to batch the unixodbc module and it runs
with the error I just report.
(http://openser.org/pipermail/users/2007-August/012532.html)
 
Please help,

Regards
Tung


> 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
> 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/12b4a8c8/attachment.htm