Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Looking for Microsoft OLE DB Provider for Oracle

Posted on 2006-11-23
3
Medium Priority
?
1,407 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
sivachirravuri earned 1400 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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

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…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
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…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

636 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