Re: Access 2003 ODBC front end for Oracle 9i Database

Giganews Newsgroups
Subject: Re: Access 2003 ODBC front end for Oracle 9i Database
Posted by:  Sybrand Bakker (sybran…@hccnet.nl)
Date: Tue, 04 Jan 2005

On 4 Jan 2005 12:46:13 -0800, jamesnova…@gmail.com wrote:

>I have heard that it is possible to have some DLL's and perhaps the
>SQLNET and TNSNAMES files present on the workstation WITHOUT the client
>installed and be able to use the Microsoft Oracle ODBC driver to
>connect.

They have been telling you fairy tales or you heard wrong. Any ODBC
driver for Oracle needs the full client, with the exception of
possibly Merant.
Mickeysoft's ODBC driver definitely doesn't work with Oracle without a
client.
You definitely need to install the ODBC driver and the full client in
a separate ORACLE_HOME and set up the registry string var TNS_ADMIN
(in hklm\software\oracle) to point to the correct directory holding
tnsnames.ora

--
Sybrand Bakker, Senior Oracle DBA

Replies

In response to

Access 2003 ODBC front end for Oracle 9i Database posted by jamesnova…@gmail.com on 4 Jan 2005