Solved

Looking for Microsoft OLE DB Provider for Oracle

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now