"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:uja99f5dgig13f_at_corp.supernews.com...
>
> "Randy Harris" <randy.harris_at_nospam.net> wrote in message
> news:JV3Z8.13011$t%5.6332073_at_newssvr28.news.prodigy.com...
> > Can someone please tell me how a MS Access application decides which
> Oracle
> > version to use if there is more than one installed?
<snip>
> Ms Access doesn't choose anything. The driver being used in the ODBC DSN
> will determine which software to use.
> That being said, multiple homes can be a can of worms especially when you
> have the newest home *first* in your PATH.
> With respect to tnsnames.ora this can be prevented by setting the
TNS_ADMIN
> registry variable.
Just to add a little bit. MS Access doesn't have to use ODBC (though it most
commonly does) but can use an OLEDB provider. In this case you do have to
set TNS_ADMIN (either in the registry or as an environment variable) and
probably ORACLE_HOME as well.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Wed Jul 17 2002 - 04:02:21 CDT
