How To Acquire and Install the Microsoft Oracle ODBC Driver

Retired KB Content Disclaimer

View products that this article applies to.

This article was previously published under Q175018

SUMMARY

This article describes the procedures for acquiring and installing the Microsoft Oracle ODBC Driver version 2.5, which is a component of the Microsoft Data Access Components (MDAC) version 2.0 and higher.

Back to the top

MORE INFORMATION

The Microsoft Oracle ODBC Driver version 2.5 is part of the Microsoft Data Access Components version 2.0 and 2.1. You will need to download this "stack" from the Microsoft Web site and install them. The Microsoft Oracle ODBC Driver version 2.5 is available with Visual Studio 6.0, MDAC 2.0 and 2.1, and the Data Access Software Development Kit (SDK) 2.0.

NOTE: There is no way to acquire the Microsoft Oracle ODBC Driver v2.0 outside of the MDAC stack. The driver was developed and tested with the components in the stack and that is the best way to install and use the driver.

Back to the top

Step-by-Step Example

Go to the Microsoft Universal Data Access Web site located at the following Web URL:
http://msdn.microsoft.com/dataaccess (http://msdn.microsoft.com/dataaccess)
On the Web site, click the Downloads link listed under the UDA Contents on the left of the page. This displays a page that lists the available free downloads.
Click the link titled "Download MDAC 2.1.1.4202.3 (GA)" to open the download page for the MDAC 2.1 SP2 stack. Please read through the information on this page pertaining to system and software requirements.
Follow the on download intructions given on the website.
Click on the link titled "Download the Microsoft Data Access SDK version 2.0 and the Microsoft Data Access Components version 2.0".

Once the MDAC 2.1 SP2 installation is complete, you should see the Microsoft Oracle ODBC Driver version 2.5 listed under the Drivers tab of your ODBC Manager as follows:

      NAME:      Microsoft ODBC for Oracle

      VERSION:   2.573.4202

      COMPANY:   Microsoft Corporation

      FILE:      MSORCL32.DLL

      DATE:      6/4/99

For information about setting up a data source name (DSN) for the Microsoft Oracle ODBC Driver version 2.5, please consult the Help file for the driver. The Help file for the driver was installed in the appropriate SYSTEM directory (i.e. SYSTEM for Windows 95 and Windows 98, and SYSTEM32 for NT) along with the driver DLL. The name of the Help file is MSORCL32.HLP.

Back to the top

REFERENCES

For more information on how to use this driver with RDO version 2.0,please see the following articles in the Microsoft Knowledge Base:

167225 (http://support.microsoft.com/kb/167225/EN-US/ ) How To Access an Oracle Database Using RDO

174679 (http://support.microsoft.com/kb/174679/EN-US/ ) How To Retrieve Resultsets from Oracle Stored Procedures

174981 (http://support.microsoft.com/kb/174981/EN-US/ ) "How To Retrieve Typical Resultsets From Oracle Stored Procedures

Back to the top

APPLIES TO

Microsoft Open Database Connectivity 2.5
Microsoft Open Database Connectivity 2.0
Microsoft Data Access Components 2.1

Back to the top

kbdatabase kbdriver kbhowto kboracle kbsetup KB175018

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top