<!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=418031810-03102007><FONT face=Arial
color=#0000ff>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=418031810-03102007><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=418031810-03102007><FONT face=Arial color=#0000ff>please send
me the structure of your location table.</FONT></SPAN></DIV>
<DIV><SPAN class=418031810-03102007><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=418031810-03102007><FONT face=Arial
color=#0000ff>regards</FONT></SPAN></DIV>
<DIV><SPAN class=418031810-03102007><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=418031810-03102007><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> Wednesday, October 03, 2007 8:55 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">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>