Access/ODBC/Oracle Outer Join

From: Jeremy Eric Mortis <mortis_at_acs.ucalgary.ca>
Date: Mon, 8 Aug 1994 21:05:03 GMT
Message-ID: <Aug8.210503.49414_at_acs.ucalgary.ca>


I am having a problem with outer joins in Access/ODBC/Oracle. They are frequently ignored. If I look at SQLOUT.TXT, I see that the outer join specification is missing from the generated SQL statement, even though it is there in the Access SQL view.

I reported the problem to Microsoft. They claim the problem is with Oracle's ODBC driver. Apparently the SQLOUT.TXT file is the output FROM the ODBC driver, not the input TO.

As far as I know, the 1.10 version of the Oracle ODBC driver is the most recent one (we can't afford CompuServe).

Is there a newer one? Does anyone know if Oracle is putting any effort to creating an industrial strength ODBC driver?

--


 Jeremy E. Mortis                           Internet: mortis_at_acs.ucalgary.ca   
 Financial Information Services                        Phone: (403) 220-4423
 University of Calgary Computing Services                Fax: (403) 282-9361
Received on Mon Aug 08 1994 - 23:05:03 CEST

Original text of this message