January 7, 2014 at 1:31 am
Hi All,
When I connect oracle from SSIS got following error message.
"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"
Please help.
Thanks & Regards,
Vinod
January 7, 2014 at 2:30 am
Did you install the client?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 7, 2014 at 2:34 am
Yes.. oracle client also there.
January 7, 2014 at 2:46 am
vkmnair (1/7/2014)
Yes.. oracle client also there.
On the development machine, in the 32-bit version?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 7, 2014 at 3:48 am
yes .. i think so.. may knowhow to check client bit version?
January 7, 2014 at 4:11 am
Maybe you can check it with the Oracle Universal Installer?
(I can't verify this myself right now)
You can also ask such questions on an Oracle dedicated forum, they might provide better assistence.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 7, 2014 at 9:52 pm
I have installed 64bit oracle client in my machine.. still unable to connect oracle.
Regards
VInod
January 8, 2014 at 12:07 am
vkmnair (1/7/2014)
I have installed 64bit oracle client in my machine.. still unable to connect oracle.Regards
VInod
You need the 32-bit client to be able to connect to Oracle in BIDS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 8, 2014 at 12:09 am
vkmnair (1/7/2014)
I have installed 64bit oracle client in my machine.. still unable to connect oracle.Regards
VInod
You need the 32-bit client to be able to connect to Oracle in BIDS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 8, 2014 at 12:10 am
vkmnair (1/7/2014)
I have installed 64bit oracle client in my machine.. still unable to connect oracle.Regards
VInod
You need the 32-bit client to be able to connect to Oracle in BIDS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 8, 2014 at 9:38 pm
Dear Koen,
Could you please help me to undestand why which required bith 64 & 32 bit version of oracle client.
I have already requested to my system admin to install "Oracle Data Access Components (ODAC) for Visual Studio". is this help me to resolve my issue.
Thanks & Regards,
Vinod
January 8, 2014 at 11:51 pm
vkmnair (1/8/2014)
Dear Koen,Could you please help me to undestand why which required bith 64 & 32 bit version of oracle client.
I have already requested to my system admin to install "Oracle Data Access Components (ODAC) for Visual Studio". is this help me to resolve my issue.
Visual Studio is 32-bit, so you need the 32-bit client so that you can connect to Oracle when designing your package.
64-bit client is needed when you run the package outside of BIDS.
If I'm not mistaken, ODAC will install the Oracle OLE DB provider, which can be pretty useful for connecting to Oracle.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 9, 2014 at 3:56 am
it's working Koen.. 🙂
I have installed 32 bit client also.. now I am able to connect oracle database from VS.
Thanks a lot for your support..
Regards,
Vinod
January 9, 2014 at 4:11 am
vkmnair (1/9/2014)
it's working Koen.. 🙂I have installed 32 bit client also.. now I am able to connect oracle database from VS.
Thanks a lot for your support..
Regards,
Vinod
No problem, glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 9, 2014 at 8:23 am
In that server, environment variable u can set oracle 32 bit version path .it will work
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply