Re: Converting Access queries to ANSI SQL

Here are two ideas/comments, not sure if they really help:

• Someone commented on the switch on the ODBC manager. It logs the SQL generated by Access when it uses an external ODBC source. No help if the tables are in the local Access database.

    If you look at the log, you'll have a lot of garbage to sift through because

    it logs individual fetches.

• If you are using Access to go to Oracle, you can look at V$SQLAREA or V$SQLTEXT to see the actual code. It takes some work. I have done it occassionally.

 Also keep in mind whether using ODBC or the V$ views that ODBC and Access may do extra work. So you are not looking at the entire processing (please someone prove me wrong).

Good Luck,

Richard

> Tim Nutman <timn_at_sdsapps.co.uk> wrote in article
> <3301C6DC.266F_at_sdsapps.co.uk>...
> > I am currently converting a MS-Access database into Oracle.
> > I am having a problem with re-writing all the MS-Access queries
> > into ANSI SQL for the Oracle version of the database. The problem
> > is two-fold.
Received on Fri Feb 14 1997 - 00:00:00 CET