Re: ODBC/MS Access query discrepancies

In article <5qgnpo$39f$1_at_dwapara.intermec.com>, kkost_at_intermec.com (Kathy Kost) wrote:
>
>Hello all....
>
>We have an application within Microsoft Access that queries our Oracle7
>RS6000 server. We have another application that utilizes SQL*Net/ODBC
>and we wish to run the same queries with it. So, I have been taking some
>of the queries and copying then to run within the ODBC test program. As
>long as the sql syntax and the queries are simplistic, I have no problems.
>However, when I start doing more complex queries, such as those with joins,
>the syntax bombs with the ODBC test program (however the same query works
>fine within Access). It looks to me (whether correct or not) that Access
>is somehow changing the query sql code to something other than it shows me
>in order to get the query accepted by the database server. Can someone
>tell me if this is indeed what is happening and point me to some decent
>documentation on this? Or tell me that this is a stupid question and point
>me in the right direction? (Unix admin blindly stumbling into Microsoft
>territory... :-) )
>
>Here's the version info:
>
>On Win95:
>Microsoft Access 2.0
>Oracle7 ODBC Driver for Oracle7 1.11.0.5,1.11.1.5
>SQL*Net 2.2.2.0.3A
>
>Thanks for the help!
>
>Kathy Kost
>kkost_at_intermec.com

Are you using pass-through queries? You might check on that.

Bill Received on Wed Jul 16 1997 - 00:00:00 CDT