Solved

Looking for Microsoft OLE DB Provider for Oracle

Posted on 2006-11-23
3
1,330 Views
Last Modified: 2013-11-25
Hello,

I'm working with Visual Studio 2003 .NET.
I'm having problems trying to design a Crystal Report (using Crystal Report .NET 2003) and connect Crsytal Report to Oracle 10g Database using Microsoft OLE DB Provider for Oracle. I got this error:
ADO Error Code 0x80004005

So, I think that I should download the latest Microsoft OLE DB Provider for Oracle.
I'm trying to find it in Microsoft page, but I found one which is quite old:

oracle_net.msi
version: 1.0
Date: 31/07/2002

Can somebody help point for me from where to download it?
0
Comment
Question by:miyahira
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
sivachirravuri earned 350 total points
ID: 18005715
Hi Use following link,

http://www.oracle.com/technology/software/tech/windows/odpnet/index.html

Additional information
^^^^^^^^^^^^^^

Oracle Provider for OLE DB (OraOLEDB) offers high performance and efficient access to
Oracle data by OLE DB consumers.

Download Includes:

a) Oracle Universal Installer
b) Oracle Provider for OLE DB (8.1.7.3.0)
c) Oracle Client (8.1.7.0.0)
d) Oracle Services for MTS (8.1.7.0.0)



OraOLEDB System Requirements
============================

The following items are required on a system to use Oracle Provider for OLE DB:

- Windows 95/98, Windows NT 4.0, Windows 2000, Windows XP Professional

- Access to an Oracle Database Server (release 7.3.4 or later)

- Oracle Client (release 8.1.7)

- Oracle Provider for OLE DB(8.1.7.3.0)

- Redistributable files provided with MDAC 2.1, 2.5, or 2.6 (www.microsoft.com/data/oledb)

- Oracle Services for Microsoft Transaction Server (version 8.1.7.0.0). Required only for consumers using MTS.

Instructions for Installing Oracle Provider for OLE DB
======================================================



1. Download OraOLEDB_81730.zip onto a temporary folder.

2. Unzip OraOLEDB_81730.zip using a decompression program, such as WinZip.

3. Run the Oracle Universal Installer in \install\win32\setup.exe to complete the
installation of the provider. The is the directory where you extracted all the zipped files to.

4. After the installation, delete OraOLEDB_81730.zip and the temporary
installation folders and files.

5. For Windows 95/98 users, a reboot is required after the OraOLEDB installation is complete.

Please note: Do not download this file into the "Tmp" directory.  

Viewing the Documentation
===========================
The Oracle Provider for OLE DB documentation is installed in the ORACLE_HOME\oledb\doc
directory. To view the online PDF or HTML documentation, open the oledb.pdf file in the
ORACLE_HOME\oledb\doc directory or the toc.htm file in the
ORACLE_HOME\oledb\doc\html directory.
0
 
LVL 1

Author Comment

by:miyahira
ID: 18009419
I had to reinstall the Oracle Client 10g. That was the problem.
Thanks anyway.
0
 
LVL 5

Expert Comment

by:sivachirravuri
ID: 18017178
Thts Great.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question