<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1595" name=GENERATOR>
<STYLE type=text/css>BODY {
FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma'; font-color: '#000000'
}
LI {
DISPLAY: list-item; MARGIN: 0in
}
P {
DISPLAY: block; MARGIN: 0in
}
BODY {
}
</STYLE>
</HEAD>
<BODY>
<DIV><SPAN class=951550607-05102007><FONT face=Arial color=#0000ff>Hi
Tung,</FONT></SPAN></DIV>
<DIV><SPAN class=951550607-05102007><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=951550607-05102007><FONT face=Arial color=#0000ff>yes it is
possible because the Query looks like a little bit strange. Maybe you
should check out the</FONT></SPAN></DIV>
<DIV><SPAN class=951550607-05102007><FONT face=Arial color=#0000ff>newest
version of OpenSER......because i watched my Query and it looks
okay.</FONT></SPAN></DIV>
<DIV><SPAN class=951550607-05102007><FONT face=Arial color=#0000ff>Give it a try
an tell me if it is running or not!</FONT></SPAN></DIV>
<DIV><SPAN class=951550607-05102007><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=951550607-05102007><FONT face=Arial color=#0000ff>kind
regards,</FONT></SPAN></DIV>
<DIV><SPAN class=951550607-05102007><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=951550607-05102007><FONT face=Arial
color=#0000ff>Martin</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> Tung Tran [mailto:tr.tung@gmail.com]
<BR><B>Sent:</B> Thursday, October 04, 2007 9:29 AM<BR><B>To:</B> Gruber Martin
(IFKL IT OS NV)<BR><B>Cc:</B> users@openser.org<BR><B>Subject:</B> RE:
[OpenSER-Users] Error when connect to Oracle via ODBC.<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt">Mr. Martin,</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt">Sorry the errors are not disappear after I
change the username to not null. </SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt">I think the errors should be in this
query</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy"> 1(14057)
unixodbc:SQLExecDirect, rv=-1. Query= <B>select received, contact, socket,
cflags from location where expires > now() and cflags & 64 =
64</B></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy"> 1(14057)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">If I copy this query and run
directly on Oracle then I got error too, but I change the query to</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy"> "<B>select
received, contact, socket, cflags from location where expires > now() and
cflags = 64</B>"</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">then it works, </SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">Do you think there is a bug in
the code ? </SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">Regards,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy"><BR>Tung</SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt"><BR><BR></SPAN></DIV>
<DIV class=body><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> he fields with
Datatype number - constrain them to a distinct size</SPAN><SPAN
style="FONT-SIZE: 10pt"><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">> I think you should set the
"expires" and "last_modified" field to</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> date and not timestamp. And
also a small hint.....the fields with</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> Datatype number - constrain
them to a distinct size. username</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> should not be nullable!
hope this helps, otherwise contact me! </SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> 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: Wednesday, October
03, 2007 4:15 PM</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">> Hi,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> This is the structure of my
location table.</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> If you need any information
please let me know..</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> Thanks for your help in
advanced</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">> 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">>> Hi,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> please send me the
structure of your location table.</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">>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 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 8:55 AM</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">>> Dear
Martin,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 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: maroon">>> also follow the guide
on web to batch the unixodbc module and it</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> runs with the error I
just report.</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> (<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: maroon">>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> Please
help,</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">>>> what version of
OpenSER do you use. Seems that something in the</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> source is not
running well. Check out the newest version first.</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> If it is not the
case let me know!</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:
users-bounces@openser.org [<A href="mailto:users">mailto:users</A>-</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
bounces@openser.org] On Behalf Of Tung Tran Sent: Wednesday,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> October 03, 2007
7:18 AM To: users@openser.org</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> Subject:
[OpenSER-Users] Error when connect to Oracle via 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">>>> Hi
all,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> I am trying to
connect Openser with Oracle via odbc. So far I</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> can</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> connect
sucessfully to Oracle DB via unixODBC module, I can</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> register and make
call,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> However I got
this error from Openser debug that I dont know it</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> may effect to
Openser operation</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> 00920: invalid
relational operator</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> 00920: invalid
relational operator</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> 1(9499)
db_raw_query: Error while submitting query 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect, rv=100. Query= delete from location</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
where</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
expires</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')
</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> 1(9499)
unixodbc:SQLExecDirect, rv=-1. Query= select received,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> contact, socket,
cflags from location where expires > now() and</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> cflags & 64 =
64 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> invalid
relational operator 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> invalid
relational operator </SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> 1(9499)
db_raw_query: Error while submitting query 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> socket, cflags
from location where expires > now() and cflags &</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> 64 = 64
1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> invalid
relational operator 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> invalid
relational operator </SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> 1(9499)
db_raw_query: Error while submitting query 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> socket, cflags
from location where expires > now() and cflags &</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> 64 = 64
1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> invalid
relational operator 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> invalid
relational operator </SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> Should anyone
sucess customize Openser to work smoothly with</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> Oracle? please
help.</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>> Thanks and
regards</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: purple">>>>
Tung</SPAN></DIV></BODY></HTML>