Solved

Looking for Microsoft OLE DB Provider for Oracle

Posted on 2006-11-23
3
1,339 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 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