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

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Tue, 04 Jan 2005 23:10:55 +0100
Message-ID: <8t4mt01caam9fi5bigqg4mh7svfccij7a7@4ax.com>

On 4 Jan 2005 12:46:13 -0800, jamesnovara_at_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

Received on Tue Jan 04 2005 - 16:10:55 CST