469,307 Members | 1,583 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,307 developers. It's quick & easy.

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 1021

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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.