Dear Mr.Martin,
Thanks for your support so far, I am using newest patch 1.2.2 (stable version) on Openser website. Actually I dont know how to get the last svn to make a new test.
Probably I will wait for new release 1.3?
Tung
> 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
>
> Sent: Thursday, October 04, 2007 9:29 AM
> To: Gruber Martin (IFKL IT OS NV)
> Cc: users@openser.org
> 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
>>
>> Sent: Wednesday, October 03, 2007 4:15 PM
>> To: Gruber Martin (IFKL IT OS NV)
>> Cc: users@openser.org
>> 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
>>>
>>> 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.
>>>
>>> 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
>>>>
>>>> bounces@openser.org] 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