<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 Mr.Martin,</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">Thanks for your support so far, I am using newest patch 1.2.2 (stable version) on Openser website. Actually I dont know how to get the last svn to make a new test.</SPAN></div>
<div><SPAN style="font-size:10pt;">Probably I will wait for new release 1.3? </SPAN></div>
<div><SPAN style="font-size:10pt;">Tung<br /><br /></span></div>
<div><SPAN style="font-size:10pt;color:navy;">> Hi Tung,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> yes it is possible because the Query looks like a little bit</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> strange. Maybe you should check out the</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> newest version of OpenSER......because i watched my Query and it</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> looks okay. Give it a try an tell me if it is running or not!  </SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> kind regards,   Martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> From: Tung Tran [<a href="mailto:tr.tung@gmail.com]">mailto:tr.tung@gmail.com]</a></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Sent: Thursday, October 04, 2007 9:29 AM</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> To: Gruber Martin (IFKL IT OS NV)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Cc: users@openser.org</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Subject: RE: [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;">> Mr. Martin,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Sorry the errors are not disappear after I change the username to</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> not null. I think the errors should be in this query    1(14057)</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(14057)</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   If I copy this query and run directly</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> on Oracle then I got error too, but I change the query to    </SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> "select received, contact, socket, cflags from location where</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> expires > now() and cflags  = 64"   then it works,   Do you think</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> there is a bug in the code ?   Regards,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Tung</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:maroon;">>> he fields with Datatype number - constrain them to a distinct size</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> I think you should set the "expires" and "last_modified" field to</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> date and not timestamp. And also a small hint.....the fields with</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Datatype number - constrain them to a distinct size. username</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> should not be nullable!   hope this helps, otherwise contact me!  </SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>>  regards Martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> From: Tung Tran [<a href="mailto:tr.tung@gmail.com]">mailto:tr.tung@gmail.com]</a></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Sent: Wednesday, October 03, 2007 4:15 PM</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> To: Gruber Martin (IFKL IT OS NV)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Cc: users@openser.org</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Subject: RE: [OpenSER-Users] Error when connect to Oracle via</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> ODBC.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> This is the structure of my location table.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> If you need any information please let me know..</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Thanks for your help in advanced</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Tung</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> please send me the structure of your location table.</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> From: Tung Tran [<a href="mailto:tr.tung@gmail.com]">mailto:tr.tung@gmail.com]</a></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Sent: Wednesday, October 03, 2007 8:55 AM</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> To: Gruber Martin (IFKL IT OS NV)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Cc: users@openser.org</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Subject: RE: [OpenSER-Users] Error when connect to Oracle via</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> ODBC.</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Dear Martin,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> I am using Openser 1.2.2 and the odbc lib is libsqora.so.10.1 I</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> also follow the guide on web to batch the unixodbc module and</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> it runs with the error I just report.</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> (<a href="http://openser.org/pipermail/users/2007-August/012532.html">http://openser.org/pipermail/users/2007-August/012532.html</a>)</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Please help,</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>> Tung</SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:purple;">>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> Hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> what version of OpenSER do you use. Seems that something in</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> the source is not running well. Check out the newest version</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> first. If it is not the case let me know!</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> Martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> From: users-bounces@openser.org [<a href="mailto:users">mailto:users</a>-</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> bounces@openser.org] On Behalf Of Tung Tran Sent: Wednesday,</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> October 03, 2007 7:18 AM To: users@openser.org Subject:</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> [OpenSER-Users] Error when connect to Oracle via ODBC.</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> Hi all,</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> I am trying to connect Openser with Oracle via odbc. So far I</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> can</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> connect sucessfully to Oracle DB via unixODBC module, I can</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> register and make call,</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> However I got this error from Openser debug that I dont know</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> it may effect to Openser operation</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 00920: invalid relational operator</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 00920: invalid relational operator</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect, rv=100. Query= delete from location</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> where expires</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> HH24:MI:SS')   1(9499) unixodbc:SQLExecDirect, rv=-1. Query=</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> select received, contact, socket, cflags from location where</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> expires > now() and cflags & 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 00920: invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 00920: invalid relational operator  </SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect, rv=-1. Query= select received,</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> contact, socket, cflags from location where expires > now()</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> and cflags & 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 00920: invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 00920: invalid relational operator  </SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect, rv=-1. Query= select received,</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> contact, socket, cflags from location where expires > now()</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> and cflags & 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 00920: invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> 00920: invalid relational operator    </SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> Should anyone sucess customize Openser to work smoothly with</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> Oracle? please help.</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>></SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> Thanks and regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:blue;">>>>> Tung</SPAN></div>
</body></html>