Re: ODBC/MS Access query discrepancies

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

Hello Ms. Kost,

If you are not using pass-through-queries you are partially correct in your assumption that the SQL query is being changed. It is. But not by Access, but by the ODBC driver. You'll have to check the ODBC driver's documentation to find out what/how it translates SQL to the server's "standard."

There's a fair discussion of ODBC & Access in _MS Access 95 Developer's Handbook_, by Litwin, Getz, et. al. if you care to purchase/borrow (from your local library) this weight tome.

Regards,

-- 
M. G. Foster:::mgf
Oakland, CA
Email:  Remove the NOSPAM in the address to respond.