Access SQL on Oracle Tables thru ODBC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need some help. When I run a SQL statement on an Oracle table linked thru
ODBC in Access 2002, I am getting incorrect results. When I run the same SQL
directly in Oracle on the table, the results are correct. Can someone explain
what the problem may be please?

Thanks,
Tanfer
 
Each flavour of SQL is slightly different from others. If the SQL works in
PL/SQL, you probably need to modify it only slightly so that it works in JET
/ SQL since SQL on ODBC-linked Table is first handled by JET and JET may
then pass portion of the processing to Oracle.

Provide you don't need to update data, use the working SQL in a Pass-Through
Query is the most effcient way.
 
Back
Top