Re: Problems with ODBC

From: Mark Wagoner <mwagoner_at_iac.net>
Date: 1996/05/07
Message-ID: <4mngol$o1d_at_cheyenne.iac.net>#1/1


rob.bezaire_at_canrem.com (Rob Bezaire) wrote:

> I'm having trouble setting up a Windows NT client to access an Oracle
>7 server. The client has SQL*Net version 1.1 installed and the 16 bit ODBC
>driver from Oracle. The intention is to use MS Access Version 2.0 to connect
>to the Oracle server.
 

> After we made a copy of the ORANT.DLL and called it ORA71WIN.DLL, the
>ODBC driver installed OK. However, MS Access gets the following errors when
>trying to attach tables:
 

> ODBC Call Failed
>Clicking on the OK button yielded the additional message:
> MS ODBC DLL specified driver could not be loaded
 

>Any help would be appreciated.
 

>Thanks,
 

>Rob Bezaire
>(rbezaire_at_inforamp.net)

I don't think you can just rename a DLL like that. It appears you have the 32-bit version of SQL*Net loaded (the ORANT.DLL) but Access wants 16-bit (the ORA71WIN.DLL). Try installing 16-bit SQL*Net.

--
Mark Wagoner
mwagoner_at_iac.net
Received on Tue May 07 1996 - 00:00:00 CEST

Original text of this message