<!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=932134106-04102007><FONT face=Arial
color=#0000ff>hi,</FONT></SPAN></DIV>
<DIV><SPAN class=932134106-04102007><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=932134106-04102007><FONT face=Arial color=#0000ff>I think you
should set the "expires" and "last_modified" field to date and not
timestamp.</FONT></SPAN></DIV>
<DIV><SPAN class=932134106-04102007><FONT face=Arial color=#0000ff>And also a
small hint.....the fields with Datatype number - constrain them to a distinct
size.</FONT></SPAN></DIV>
<DIV><SPAN class=932134106-04102007><FONT face=Arial color=#0000ff>username
should not be nullable!</FONT></SPAN></DIV>
<DIV><SPAN class=932134106-04102007><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=932134106-04102007><FONT face=Arial color=#0000ff>hope this
helps, otherwise contact me!</FONT></SPAN></DIV>
<DIV><SPAN class=932134106-04102007><FONT face=Arial
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=932134106-04102007><FONT face=Arial
color=#0000ff>regards</FONT></SPAN></DIV>
<DIV><SPAN class=932134106-04102007><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 4:15 PM<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">Hi,</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt">This is the structure of my location
table.</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt">If you need any information please let me
know..</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt">Thanks for your help in advanced</SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt">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">> please send me the
structure of your location table.</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: 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 8:55 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">> Dear Martin,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> 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: navy">> also follow the guide on
web to batch the unixodbc module and it</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> runs with the error I just
report.</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> (<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: navy">></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: navy">> Please help,</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">>> what version of
OpenSER do you use. Seems that something in the</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> source is not running
well. Check out the newest version first.</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> If it is not the case
let me know!</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:
users-bounces@openser.org [<A href="mailto:users">mailto:users</A>-</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> bounces@openser.org]
On Behalf Of Tung Tran Sent: Wednesday,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> October 03, 2007 7:18
AM To: users@openser.org</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> Subject:
[OpenSER-Users] Error when connect to Oracle via 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 all,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> I am trying to
connect Openser with Oracle via odbc. So far I can</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> connect sucessfully
to Oracle DB via unixODBC module, I can</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> register and make
call,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> However I got this
error from Openser debug that I dont know it</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> may effect to Openser
operation</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 1(9499)
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 00920: invalid
relational operator</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 1(9499)
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 00920: invalid
relational operator</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 1(9499) db_raw_query:
Error while submitting query 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
unixodbc:SQLExecDirect, rv=100. Query= delete from location where</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> expires</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')
</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 1(9499)
unixodbc:SQLExecDirect, rv=-1. Query= select received,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> contact, socket,
cflags from location where expires > now() and</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> cflags & 64 = 64
1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> invalid relational
operator 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> invalid relational
operator </SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 1(9499) db_raw_query:
Error while submitting query 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> socket, cflags from
location where expires > now() and cflags &</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 64 = 64
1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> invalid relational
operator 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> invalid relational
operator </SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 1(9499) db_raw_query:
Error while submitting query 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> socket, cflags from
location where expires > now() and cflags &</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> 64 = 64
1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> invalid relational
operator 1(9499)</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> invalid relational
operator </SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> Should anyone sucess
customize Openser to work smoothly with</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> Oracle? please
help.</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>></SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>> Thanks and
regards</SPAN></DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; COLOR: maroon">>>
Tung</SPAN></DIV></BODY></HTML>