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

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

I've created the issue. I don't know how to trace the execution of the statement in Firebird. Maybe you can give me an manual for doing this?

I have only one further statement which works:
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 TRIM(us.USER_LOGIN) = 'ADMIN'

But inserting a trim should not be the solution..

-----Ursprüngliche Nachricht-----
Von: Alexander Potapchenko [mailto:ale...@re...] 
Gesendet: Dienstag, 13. Januar 2009 15:53
An: fir...@li...
Betreff: Re: [Firebird-odbc-devel] selecting from Oracle 11g to firebird

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

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Firebird-odbc-devel mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

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