Re: How to use MS ODBC drivers for Oracle

Imran,

    Let me help you clear the confusion.

First, the Microsoft ODBC drivers for Oracle will not work with Oracle Version 8.0.4. You need to install the Oracle ODBC Drivers from the Oracle8 installation CD.

Second, go into Windows NT Control Panel and open ODBC Administration and verify that the driver (Oracle ODBC Driver, Version 8.00.0400) is listed under the "Drivers" tab.

Third, configure a System DSN to connect to the database.

I have a local Oracle 8.0.4 database running on my Windows NT Server 4.0 machine and I configured the TNSNAMES.ORA for a "named pipes" connection called NT_Pipe.world. You can do the same for a TCP/IP, IPX, etc. connection to a remote machine. Anyway, to configure the Oracle8 ODBC driver enter the EXACT connect name in the ODBC->Configure->Service Name, i.e. in my case NT_Pipe.world. Then enter the UserID (I use SYS since I'm administering the database). All that's left is to enter a data source name and description (optional).

Your clients must have the SQL*Net drivers and Oracle ODBC drivers installed. as well as a properly configured TNSNAMES.ORA and SQLNET.ORA. Hope this helps.

Allan Kelly

Imran Hussain wrote in message <36DC794C.417DAA6D_at_imranweb.com>...
>Hi,
>I need to know if there is any special setting required for using
>Microsoft ODBC driver for Oracle. I downloaded the ODBC driver from
>Oracle web site and they work fine but there is one glitch in the driver
>and I want to see if that exists in the MS implementation of the driver.
>However, when I try to create an ODBC DSN, it tell me that Oracle client
>is not installed, even though it is installed.
>
>Thanks,
>Imran.
>--
>===========================================
>Imran Hussain
>MCP, MCSD
>imranh_at_imranweb.com
>For FREE Software http://www.imranweb.com/freesoft
>===========================================
Received on Sun Mar 14 1999 - 00:00:00 CET