Re: Problems with ODBC

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:

This was the mistake, you cannot use a 32 Bit DLL (ORANT.DLL) where a 16 Bit is used (ORA71WIN.DLL). You have to install the ORA71WIN.DLL from your CD-Rom. To install it install a 16 bit Oracle Client Program e.g. SQLPlus 3.1 or SQLForms 4.5...

>
> 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)
 

-- 
----------------------------------------------------------
           IMSoft - Dipl.-Ing. Michael Karg
             Graf Starhemberggasse 32/2/3
                      1040 Wien
                       Austria
----------------------------------------------------------
e-mail   : karg_at_uranus.tuwien.ac.at
Tel & Fax: ++43/1/5056190
WWW      : http://uranus.tuwien.ac.at/~karg/imsoft.html