Hi Tung, yes it is possible because the Query looks like a little bit strange. Maybe you should check out the newest version of OpenSER......because i watched my Query and it looks okay. Give it a try an tell me if it is running or not! kind regards, Martin
________________________________ From: Tung Tran [mailto:[EMAIL PROTECTED] Sent: Thursday, October 04, 2007 9:29 AM To: Gruber Martin (IFKL IT OS NV) Cc: [email protected] Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC. Mr. Martin, Sorry the errors are not disappear after I change the username to not null. I think the errors should be in this query 1(14057) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags from location where expires > now() and cflags & 64 = 64 1(14057) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator If I copy this query and run directly on Oracle then I got error too, but I change the query to "select received, contact, socket, cflags from location where expires > now() and cflags = 64" then it works, Do you think there is a bug in the code ? Regards, Tung > he fields with Datatype number - constrain them to a distinct size > hi, > > I think you should set the "expires" and "last_modified" field to > date and not timestamp. And also a small hint.....the fields with > Datatype number - constrain them to a distinct size. username > should not be nullable! hope this helps, otherwise contact me! > regards Martin > > From: Tung Tran [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 03, 2007 4:15 PM > To: Gruber Martin (IFKL IT OS NV) > Cc: [email protected] > Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC. > > > Hi, > > This is the structure of my location table. > If you need any information please let me know.. > > Thanks for your help in advanced > > Regards > Tung > > >> 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: [email protected] >> 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:users- >>> [EMAIL PROTECTED] On Behalf Of Tung Tran Sent: Wednesday, >>> October 03, 2007 7:18 AM To: [email protected] >>> 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 [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
