Hi, please send me the structure of your location table. regards martin
________________________________ From: Tung Tran [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 03, 2007 8:55 AM To: Gruber Martin (IFKL IT OS NV) Cc: users@openser.org Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC. Dear Martin, I am using Openser 1.2.2 and the odbc lib is libsqora.so.10.1 I also follow the guide on web to batch the unixodbc module and it runs with the error I just report. (http://openser.org/pipermail/users/2007-August/012532.html) Please help, Regards Tung > Hi, > > what version of OpenSER do you use. Seems that something in the > source is not running well. Check out the newest version first. > If it is not the case let me know! > > regards > > Martin > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Tung Tran > Sent: Wednesday, October 03, 2007 7:18 AM > To: users@openser.org > Subject: [OpenSER-Users] Error when connect to Oracle via ODBC. > > > Hi all, > > 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, > However I got this error from Openser debug that I dont know it may > effect to Openser operation > > 1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA- > 00920: invalid relational operator > > 1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA- > 00920: invalid relational operator > > 1(9499) db_raw_query: Error while submitting query 1(9499) > ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499) > unixodbc:SQLExecDirect, rv=100. Query= delete from location where > expires > expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS') > 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, > contact, socket, cflags from location where expires > now() and > cflags & 64 = 64 1(9499) > unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: > invalid relational operator 1(9499) > unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: > invalid relational operator > 1(9499) db_raw_query: Error while submitting query 1(9499) > ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499) > unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, > socket, cflags from location where expires > now() and cflags & 64 > = 64 1(9499) > unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: > invalid relational operator 1(9499) > unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: > invalid relational operator > 1(9499) db_raw_query: Error while submitting query 1(9499) > ERROR:usrloc:get_all_db_ucontacts: raw_query failed 1(9499) > unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, > socket, cflags from location where expires > now() and cflags & 64 > = 64 1(9499) > unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: > invalid relational operator 1(9499) > unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: > invalid relational operator > Should anyone sucess customize Openser to work smoothly with > Oracle? please help. > > Thanks and regards > Tung
_______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
