The Oracle (tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use this driver until these components have been installed excel vba oracle oracleclient. Free download oracle version 7.3.3 download software at UpdateStar. Instant Client for Linux. Instant Client for Linux x86-64; Instant Client for Linux x86; Instant Client for Linux AMD64 (32-bit and 64-bit) Instant Client for Linux on Power Big Endian (32-bit). Error Description: 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 start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums
SQL Server 2005 Forums
SSIS and Import/Export (2005)
Oracle client and networking components

Oracle Version 7.3.3 Client Software Download

Author

Topic

Pherkad
Starting Member

23 Posts

Posted - 2007-04-30 : 09:50:23

hi all.
In my SSIS project, i have to retrieve data from an oracle 10g database. On my personal laptop it works, but on our test-env i get the error below, when i try to test my connection to the oracle datasource.
Could this because i have oracle XE installed yet on my personal laptop, and it is not installed on the computer of our test environment where the SSIS runs? If that's the reason, it sounds very strange, because it would mean i have to install an oracle environment also on the computer with SSIS, just to make a connection to another oracle server...
Error:
TITLE: Connection Manager
------------------------------
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.
------------------------------
BUTTONS:
OK
------------------------------

Pherkad
Starting Member

23 Posts

Posted - 2007-04-30 : 10:12:52

is it maybe the oracle instant client that i need to install on the SQL Server PC ?
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-04-30 : 10:20:58

you need to install the Oracle client first. INstant client will probably work, but I have not used it with SSIS or even with DTS. make sure you also get a copy of your tnsnames.ora so you can resolve the names of your oracle instances.
-ec

Pherkad
Starting Member

23 Posts

Posted - 2007-04-30 : 10:31:40

think i have no other choice then using the instant client.
on this page the 10g standard client is only for PowerPC/Linux. Not for windows.
http://www.oracle.com/technology/software/products/database/oracle10g/index.html
http://www.easysoft.com/support/kb/kb00612.html
or am i wrong?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-04-30 : 10:40:23

yeah, you are wrong
http://www.oracle.com/technology/software/products/database/o