I am having a hard time with this one. I'm in SSIS and have set up ODBC drivers and it's not working. I'm getting this error in 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."
I am running Windows 2003 Server on 64-bit.
Has anyone else had this problem in SSIS connecting to Oracle? My Oracle DB's are 9i. Thanks exports for all your help!