Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ODBC connection from Access to Oracle
There are some problems with some versions of Access when viewing
non keyed tables, and/or establishing a link to a table but putting
the key in wrong. Look there first.
In article <3b95c8f7$0$7109$4d4efb8e_at_news.be.uu.net>,
marcin <gormar_at_poland.com> 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 Tue Sep 18 2001 - 13:58:13 CDT