Re: ODBC connection from Access to Oracle

Is there any difference if you build your query inside a vew and then retrieved from Access?

Reid Lai

marcin wrote:

> 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:58:39 CDT