Re: Problems with ODBC

In article <4mngol$o1d_at_cheyenne.iac.net>, mwagoner_at_iac.net says...
;>
;>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
;>

I don't think that that will work. NT does NOT support the 16 bit drivers. You will have to go for the 32 bit versions of everything. This also means the latest version of Access...

Ciao

Erik Received on Wed May 08 1996 - 00:00:00 CEST