Solved

Looking for Microsoft OLE DB Provider for Oracle

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
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…

803 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