<!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><FONT face=Arial color=#0000ff><SPAN
class=051252806-03102007>Hi,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN
class=051252806-03102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=051252806-03102007>what version
of OpenSER do you use. Seems that something in the source is not running well.
Check out the newest version first.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=051252806-03102007>If it is not
the case let me know!</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN
class=051252806-03102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN class=051252806-03102007>regards
</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN
class=051252806-03102007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff><SPAN
class=051252806-03102007>Martin</SPAN></FONT></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> users-bounces@openser.org
[mailto:users-bounces@openser.org] <B>On Behalf Of </B>Tung Tran<BR><B>Sent:</B>
Wednesday, October 03, 2007 7:18 AM<BR><B>To:</B>
users@openser.org<BR><B>Subject:</B> [OpenSER-Users] Error when connect to
Oracle via ODBC.<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'">Hi all,</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'">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,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'">However I got this
error from Openser debug that I dont know it may effect to Openser operation
</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
db_raw_query: Error while submitting query</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
ERROR:usrloc:get_all_db_ucontacts: raw_query failed</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect, rv=100. Query= delete from location where
expires<to_date('2007-10-0307:53:20','YYYY-MM-DD HH24:MI:SS') AND
expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags
from location where expires > now() and cflags & 64 = 64</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
db_raw_query: Error while submitting query</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
ERROR:usrloc:get_all_db_ucontacts: raw_query failed</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags
from location where expires > now() and cflags & 64 = 64</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
db_raw_query: Error while submitting query</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
ERROR:usrloc:get_all_db_ucontacts: raw_query failed</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags
from location where expires > now() and cflags & 64 = 64</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'"> 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid
relational operator</SPAN></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'">Should anyone sucess
customize Openser to work smoothly with Oracle? please help.</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'">Thanks and
regards</SPAN></DIV>
<DIV><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial'">Tung</SPAN></DIV></BODY></HTML>