[Firebird-odbc-devel] selecting from Oracle 11g to firebird

[Hauser, K. <Kar...@ib...>]

Hi,

 

I have the following Problem with the combination of Firebird 1.5.x or 2.1, Oracle 11g and Firebird ODBC 2.00.00.148 on a winXP system:

 

the command: 
SELECT pe.NR, us.USER_LOGIN 
FROM IBKPVS_SYS_USER us 
LEFT JOIN PERSONAL@formica pe ON us.USER_PERS_ID_FK = pe.NR 
where us.USER_LOGIN = 'ADMIN'

 

ends up in this error msg:

ORA-28500: Verbindung von ORACLE zu Fremdsystem gab diese Nachricht zurück: 
[ODBC Firebird Driver]Data truncated[ODBC Firebird Driver][Firebird]Dynamic SQL Error 
SQL error code = -303 
conversion error from string " " 
ORA-02063: vorherige 4 lines von FORMICA

 

 

Other, simple statement are working like:

SELECT pe.NR FROM PERSONAL@formica pe where pe.VORNAME = 'Nicole'

 

The Problem appears when joining one table of Firebird with one of Oracle and restricting the result set. I've created a thread in the oracle forum (http://forums.oracle.com/forums/thread.jspa?threadID=845777). Here you can find the trace-information of oracle and windows. 

 

How can I solve this problem? Is there a tracing capability in Firebird? I've tried to log the failure with Dr. Watson and the debug-Version of Firebird as written in an Post on formicasql.org,  but I didn't get it working.

 

Thank you for helping

Karsten

IBYKUS AG für Informationstechnologie 
Herman-Hollerith-Str. 1 
99099 Erfurt 
Fon +49 (361) 4410-310
Fax +49 (361) 4410-410
E-Mail mailto:kar...@ib... <blocked::mailto:kar...@ib...>  
Internet http://www.ibykus.com <blocked::http://www.ibykus.com/>  


------------------------------------------------------------------------------------------------------------
IBYKUS AG für Informationstechnologie, Erfurt / HRB 108616 - D-Jena / Vorstand: Helmut C. Henkel, Dr. Lutz Richter /
Vorsitzender des Aufsichtsrates: Dr. Frieder Schäuble