473,418 Members | 2,338 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,418 software developers and data experts.

OLEDB error in SSIS

OraMaster
135 100+
Below is the error message I am getting.

"Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed."

I am working with SQL Server Integration Services (SSIS). When I am trying to select OLEDB source as Oracle 10g database I am getting this error.
Platform Details:
I have a Windows 2003 Enterprise Edition server 64 bit running SQL Server 2008 Standard Edition 64 bit with Oracle 10.2.0.1.0 64 bit client installed.

Please help me with this problem. Why I am getting this error? and what needs to be done to fix this?
Thanks in advance.
Aug 13 '10 #1
0 1091

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Coffee guy | last post by:
I'm new to .NET and web development so please forgive. What is the best way to display an error message, particularly during development. For example I handle an exception, let's say it's an...
14
by: Abhi | last post by:
FYI: This message is for the benefit of MS Access Community. I found that this prblem has been encounterd by many but there is hardly any place where a complete solution is posted. So I thought...
0
by: Ann Marinas | last post by:
Hi all! I'm developing an application that imports a CSV file then stores the imported data to an XML file through a dataset and an Access database. I've used the connection and data adapter...
4
by: Troy | last post by:
We recently installed the .Net framework on a windows 2000 server. Shortly after that we experienced intermitant problems running a web based program that accesses an Access 2002 database. The...
0
by: funky4you | last post by:
I am using a simple select query in C# app that fetches a row which has a datatime field. The query is simple "SELECT * FROM THE USERS WHERE USER_NAME = 'ABC' ", the users table contains a...
0
by: funky4you | last post by:
I am using a simple select query in C# app that fetches a row which has a datatime field. The query is simple "SELECT * FROM THE USERS WHERE USER_NAME = 'ABC' ", the users table contains a...
2
by: gelangov | last post by:
I have this problem occuring intermittently: When I try to add a package to the project, and click on the Package path button. I get a oledb error x080004005 (client unable to establish...
0
by: varughmi | last post by:
A unique issue has cropped up today in a .NET program I developed. It has been working fine for over an year until now. The program makes 2 connections total - one to a UNIT instance and another...
2
by: Michel Vanderbeke | last post by:
Hello, When you get an error in a VB.NET program, is it possible to know what is the origin of the error. I assume it can be VB.NET, the framework, a database engine, the database itself...
3
by: =?Utf-8?B?TWlrZVM=?= | last post by:
Below is the code for 2 separate functions. The first one gets data from an Access database and works fine. The second one is almost a duplicate except it gets data from an SQL database. It...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.