ODBC connection from Access to Oracle

From: marcin <gormar_at_poland.com>
Date: Wed, 5 Sep 2001 08:46:46 +0200
Message-ID: <3b95c8f7$0$7109$4d4efb8e@news.be.uu.net>

Hi guys,

my boss wants to 'query' the database which means he wants to click and get a report.
Connection from Access to Oracle (8.1.6.2) works fine, although ... simple query like "select distinct id_contracting_officer" returns different result when issued on MS Access and with SQL Plus. To be more specific, couple of records are permanently ommited by MS Access, although they exist, and are selected by _the same_ query from SQL Plus.

So , my question is if there is any magic trick with ODBC itself to do in order to get full, reliable result of the query.

best regards

marcin Received on Wed Sep 05 2001 - 01:46:46 CDT