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: 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:users-
>> [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

Attachment: table_export.csv
Description: MS-Excel spreadsheet

_______________________________________________
Users mailing list
Users@openser.org
http://openser.org/cgi-bin/mailman/listinfo/users

Reply via email to