Re: Access/ODBC/Oracle Outer Joins
Date: Thu, 23 Jun 1994 12:36:33 GMT
Message-ID: <1994Jun23.123633.21483_at_mksol.dseg.ti.com>
In article <2ua48h$1i4_at_news.tamu.edu>, rick_at_billnext.tamu.edu (Rick
Huff) writes:
|>In article <Jun22.173349.84186_at_acs.ucalgary.ca> mortis_at_acs.ucalgary.ca
(Jeremy
|>Eric Mortis) writes:
|>>
|>> We cannot get outer joins to work when accessing an Oracle
|>> database from Microsoft Access through ODBC. Does anybody else have this
|>> problem? Does anybody have a fix or workaround?
|>>
|>
|>What problem are you having exactly?
|>
|>At our site, I watched the SQL*Net between Oracle and MS-Access and
discovered
|>that Access was requesting tables one by one and then doing the join
locally.
|>
|>What I did to work around this problem was to create a view that did
the join
|>on the server and then used the view instead of the individual tables.
|>
|>Does this help you?
|>--
|>Rick Huff, Senior Systems Analyst (409) 847-9392 (rick_at_billnext.tamu.edu)
|>CIS, Computing and Information Services, Texas A&M University
Also, on a query sent by the Jet database engine through ODBC, Access allows any number of inner joins, but at most one outer join. Because of this, Jet may perform some parts of the query locally. Jet will also perform an outer join locally if the form property "Allow Updating" is set to "Any Tables".
Cheers,
Alan N. Turner "The comments expressed here are my Sr. Strategy DBA own and do not necessarily reflect Systems and Equipment Sector those of Texas Instruments, Inc. or Texas Instruments, Inc. its subsidiaries."Internet: anturner_at_sc1500.dseg.ti.com
Received on Thu Jun 23 1994 - 14:36:33 CEST