Re: Access/ODBC/Oracle Outer Joins
From: Rick Huff <rick_at_billnext.tamu.edu>
Date: 22 Jun 1994 19:43:12 GMT
Message-ID: <2ua48h$1i4_at_news.tamu.edu>
Date: 22 Jun 1994 19:43:12 GMT
Message-ID: <2ua48h$1i4_at_news.tamu.edu>
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 UniversityReceived on Wed Jun 22 1994 - 21:43:12 CEST