Re: BUG ? : Problem with Oracle OLEDB driver and Outer join

From: Etienne <etienne.lesueur_at_wanadoo.fr>
Date: Fri, 19 Jul 2002 18:28:21 +0200
Message-ID: <ah9emm$4s0$1@wanadoo.fr>

Platform :
Server SQL : Oracle 8i (8.1.5)
Client Windows 2000 + Client Oracle 8.1.7.

Here is my Visual Basic code :

Dim oConn As Object
Dim rs As Object

' Open the connection
Set oConn = CreateObject("ADODB.Connection") oConn.Open "Provider=OraOLEDB.Oracle.1;Password=test;Persist Security Info=True;User ID=test;Data Source=TEST;"

' Create the recordset
Set rs = CreateObject("ADODB.RecordSet") Set rs.Conn = oConn

' Open the recordset
rs.Open "SELECT BA.IDPIECE , BAECRGEN.ECG_LIGNE ECR_LIGNE , BAECRGEN.PIE_DATE ," + _

        "BAECRGEN.LIBELLE01 " + _
        "FROM BAPIECES  BA, BAECRGEN " + _
        "WHERE BA.IDPIECE = 999 AND BA.IDPIECE=BAECRGEN.IDPIECE (+)"

' Release resources
rs.Close
oConn.Close

Many Thanks,

Etienne

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> a écrit dans le message news: 3d36bd16$0$8513$ed9e5944_at_reading.news.pipex.net...
> how are you 'executing the query via the oldeb provider' Could you post
your
> code.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Etienne" <etienne.lesueur_at_wanadoo.fr> wrote in message
> news:ah5uoa$1s8$1_at_wanadoo.fr...
> > Hello,
> >
> > I think there is a bug in the latest version 8.1.7.3 of Oracle OLEDB
> Driver.
> >
> > When I try to execute the following query in SQL*Plus :
> >
> > SELECT BA.IDPIECE , BAECRGEN.ECG_LIGNE ECR_LIGNE , BAECRGEN.PIE_DATE ,
> > BAECRGEN.LIBELLE01
> > FROM BAPIECES BA, BAECRGEN
> > WHERE BA.IDPIECE = 999 AND BA.IDPIECE=BAECRGEN.IDPIECE (+) ;
> >
> > I retrieve 1 row (and it's right).
> >
> > When I excute the same query via the OLEDB Driver, I retrieve no rows
> !!!!!
> >
> > If there's anyway to workaround this problem ?
> >
> > Many Thanks.
> >
> > Etienne.
> >
> >
> >
> >
>
>
Received on Fri Jul 19 2002 - 11:28:21 CDT