Oracle client and networking components were not found

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!
oracle-error.doc
chrisdavis5Asked:
Who is Participating?
 
HoggZillaConnect With a Mentor Commented:
If you get a solution form MS, post it here and make it the Accepted Solution. Sorry I could not help.
0
 
HoggZillaCommented:
Why are you not using OLE DB?
Right click in Connection Manager, choose New OLE DB Connection. When the dialog comes up, choose New. Choose provider, Microsoft OLE DB Provider for Oracle. Type in the Server name: Your tnsnames entry, for your Oracle database. Login and Pwd.
Is this what you are doing?
0
 
chrisdavis5Author Commented:
Oh I'm sorry, yes I AM using OLE DB and still getting the error.  Refer to screenshot at the top of the connection manager.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
HoggZillaCommented:
My apologies, I did not even look at your screenshot.
If you are connecting to an Oracle database, you need a tnsnames file. The system knows about this tnsnames file because it is a part of the Oracle client. Can you download the Oracle client? I have never had this error because every Oracle database I connect to is located in my tnsnames.ora file. The MS Oracle provider relies on components in the Oracle client to connect.
http://www.oracle.com/technology/software/products/database/index.html 
0
 
PedroCGDCommented:
Dear Chris,
In spite of using OLEDB Source, use a DATA READER SOURCE with an ADO.NET connection in the connection manager.
I hope it help.
regards!
pedro
0
 
chrisdavis5Author Commented:
Hi guys!  This problem still exists I had to call MS Support for this one..I will split the points is that okay with you?
0
 
PedroCGDCommented:
And you tried creating the connection inside SSIS package?
Regards!
pedro
0
 
chrisdavis5Author Commented:
Yeah it has something to do with a 64-bit server and Oracle problem...I will post a link to it and accept as solution when I get back to work..yeah tried creating the connection and we finally got it working with a couple of patches you have to PAY FOR from Oracle's Metalink site.
0
 
PedroCGDConnect With a Mentor Commented:
Ok Chris!!
Regards!
Pedro
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.