MTS, ADO and Oracle

From: Stefano Mandelli <stefano.mandelli_at_ekar.it>
Date: Thu, 7 Oct 1999 15:51:48 +0200
Message-ID: <#EKY7sME$GA.211@cppssbbsa02.microsoft.com>

I develop an n-tier application with VB6 (SP3), MTS and Oracle.

I access an Oracle RDBMS (7.3.3) through ADO 2.1 (2.1.2.4202.3) and the MS OLEDB Provider.

While developing the application all works fine either debugging it outside MTS with Oracle or accessing a SQL Server 6.5 Test DB in any configuration: debugging the middle-tier component outside MTS or using the complied version.

When I tried to use the compiled middle-tier component in the MTS envirnment, at the very first SQL Query accessing the Oracle RDBMS the code stop with this ugly error:

<(0x8000FFFF) Provider: Catastrophic Failure>

The SQL query is this one:

SELECT

    TB_USER.*,
    TB_PROF.DE_PROF,
    TB_GRUP.DE_GRUP

FROM

    TB_USER,
    TB_GRUP,
    TB_PROF

WHERE
    UPPER(CE_USER) = 'UT1' AND
    TB_PROF.CD_PROF = TB_USER.CD_PROF AND     TB_GRUP.CD_GRUP = TB_USER.CD_GRUP. The question is:

Why does the compiled component (the only one that MUST work!) fails only with Oracle while in all other situations (Oracle debugged, SQL debugged and compiled) all works fine?

Thanks for any kind of help
Stefano Mandelli Received on Thu Oct 07 1999 - 08:51:48 CDT