| SQL Server, connection to oracle error [message #234223] |
Mon, 30 April 2007 08:53  |
r2d2dev
Messages: 75
Registered: May 2005
Location: bxl
|
Member |
|
|
hi all.
In my SQL Server SSIS project, when i add a datasource connection to an oracle server, i get the error below. (on my personal laptop it works fine, but when i try to install it on a test environment, i get the error)
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
------------------------------
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
