Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Problems with Microsofts ODBC driver for Oracle

Problems with Microsofts ODBC driver for Oracle

From: Fredrik Lilja <fredrik.lilja_at__NOSPAM_iconmedialab.se>
Date: 2000/04/20
Message-ID: <jDVAGgvq$GA.237@news.iconmedialab.se>#1/1

I'm developing a Data Access Layer (with Visual Basic and ADO) for an Oracle database.
I've realized that I want to use the Microsoft ODBC driver for Oracle instead
of Oracles own. When I try to set up a DSN on my workstation using the Microsoft ODBC
driver for Oracle it says that I don't have Oracle's network client installed. But that is not true,
I have an Oracle 8 client installed and I have no problem connecting to the Oracle server with
Oracle's own tools and ODBC driver.
But I don't want to use Oracle's own ODBC driver because it causes problems, I want
to use Microsofts ODBC driver for Oracle.

I have tried to set up a DSN with Microsofts ODBC driver for Oracle on the Oracle 8i server
and that was no problem, but on my client I get the error message mentioned above
My question is why the Microsoft ODBC driver for Oracle says that I don't have the
Oracle client installed. Where does it look for it ?

I have MDAC 2.5 installed (tested with 2.1 before with the same result), and I have
the Oracle 8.1.5 client tools installed.

/Fredrik Lilja
Icon Medialab
http://www.iconmedialab.se Received on Thu Apr 20 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US