From: Alexander P. <ale...@re...> - 2009-01-13 14:53:17
|
Hauser, Karsten wrote: > > 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. > > Hi, This is like a bug in the Firebird ODBC driver, but I am not sure completely. Please add it into the bug tracker here: http://tracker.firebirdsql.org/browse/ODBC Next we are resuming an analysis of this problem there soon. Now I need only a part of a trace file where is an query (SQLPrepare) which are generating the error in the SQLExecute after that. Regards, Alexander -- Alexander Potapchenko Senior developer |