<html><head><meta name="Generator" content="PSI HTML/CSS Generator"/>
<style type="text/css"><!--
body{font-family:'Tahoma';font-size:10pt;font-color:'#000000';}
LI{display:list-item;margin:0.00in;}
p{display:block;margin:0.00in;}
body{}
--></style>
</head><BODY ><div><SPAN style="font-size:10pt;">Dear Martin,</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">I am using Openser 1.2.2 and the odbc lib is libsqora.so.10.1</SPAN></div>
<div><SPAN style="font-size:10pt;">I also follow the guide on web to batch the unixodbc module and it runs with the error I just report.</SPAN></div>
<div><SPAN style="font-size:10pt;">(<a href="http://openser.org/pipermail/users/2007-August/012532.html">http://openser.org/pipermail/users/2007-August/012532.html</a>)</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">Please help,</SPAN></div>
<div><SPAN style="font-size:10pt;"><br />Regards</SPAN></div>
<div><SPAN style="font-size:10pt;">Tung<br /><br /></span></div>
<div><SPAN style="font-size:10pt;color:navy;">> Hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> what version of OpenSER do you use. Seems that something in the</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> source is not running well. Check out the newest version first.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> If it is not the case let me know!</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> From: users-bounces@openser.org [<a href="mailto:users-bounces@openser.org]">mailto:users-bounces@openser.org]</a></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> On Behalf Of Tung Tran</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Sent: Wednesday, October 03, 2007 7:18 AM</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> To: users@openser.org</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Subject: [OpenSER-Users] Error when connect to Oracle via ODBC.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Hi all,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> I am trying to connect Openser with Oracle via odbc. So far I can</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> connect sucessfully to Oracle DB via unixODBC module, I can</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> register and make call,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> However I got this error from Openser debug that I dont know it may</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> effect to Openser operation</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> 1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> 00920: invalid relational operator</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> 1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> 00920: invalid relational operator</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> unixodbc:SQLExecDirect, rv=100. Query= delete from location where</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> expires</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')  </SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> contact, socket, cflags from location where expires > now() and</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> cflags & 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> invalid relational operator  </SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> socket, cflags from location where expires > now() and cflags & 64</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> invalid relational operator  </SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> socket, cflags from location where expires > now() and cflags & 64</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> invalid relational operator    </SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Should anyone sucess customize Openser to work smoothly with</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Oracle? please help.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Thanks and regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Tung</SPAN></div>
</body></html>