Oracle7.3 with OLEDB, 'select distinct' returns duplicates

From: Charlie Dewing <charlie.dewing_at_virgin.net>
Date: 1999/08/27
Message-ID: <7q5qst$pmr$1_at_nclient11-gui.server.virgin.net>#1/1


I am having a problem using SELECT DISTINCT when targeting Oracle 7.3.3 using the Microsoft OLEDB provider for Oracle.

(NT4 SP4, Visual Studio 6 SP3, MDAC 2.1 SP1 )

Any queries using the DISTINCT clause return all rows, including duplicates.

On my machine I can get round this by setting the cursor location to adUseServer, but on a colleagues PC (same spec) a client side cursor returns duplicates, whilst a server side cursor returns nothing

This problem does not seem to occur when accessing an Oracle 8 database.

Apart from re-writing the applicable queries to avoid using 'DISTINCT' does anyone know of a fix for this?

(Moving all applications to Oracle 8 is not currently an option)

Thanks for any help

Charlie.

Crowe Insurance Group

Home: charlie.dewing<NOSPAM>_at_virgin.net Work: charlie.dewing.crowe<NOSPAM>_at_mktmail.com

Remove <NOSPAM> for email address. Received on Fri Aug 27 1999 - 00:00:00 CEST

Original text of this message