Oracle7.3 with OLEDB, 'select distinct' returns duplicates
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