Re: MTS, ADO and Oracle

You didn't read the white paper on using Oracle in an MTS environment, did you? There are some very strict guidelines for this environment.

Search for Oracle at support.microsoft.com and you will find the information that you need.

Mike

Stefano Mandelli wrote in message
<#EKY7sME$GA.211_at_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 Sun Oct 10 1999 - 12:51:39 CDT