ADO screwing up sql with Oracle odbc driver

[JCarter]

I am using ado 2.1 with the odbc driver for Oracle. When I execute my query through the Oracle odbc test utility I get the records I expect. But through the app with the added layer of ado I do not get the same results. The sql statement is an outer join between two tables: Select * From Table1,Table2 Where Table1.ID = Table2.ID (+)
Does anyone know how to solve this?

[Jaspal]

what is the code u a are using to access the database ??

maybe some details will help...

JaspaL

[JCarter]

I finally figured it out. Basically the provider I was using did not allow you to use the recordcount property of the recordset. It it was SQL select to one table the recordcount was set but if a join was involved the recordcount was -1. You can't rely on this you should check eof and bof.