472,119 Members | 1,241 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

OLEDB error in SSIS

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 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 1056

Post your reply

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

Similar topics

1 post views Thread by Coffee guy | last post: by
reply views Thread by Ann Marinas | last post: by
4 posts views Thread by Troy | last post: by
reply views Thread by funky4you | last post: by
2 posts views Thread by gelangov | last post: by
2 posts views Thread by Michel Vanderbeke | last post: by
3 posts views Thread by =?Utf-8?B?TWlrZVM=?= | last post: by
reply views Thread by leo001 | last post: by

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.