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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steve HoggITCommented:
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
Steve HoggITCommented:
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
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

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
Steve HoggITCommented:
If you get a solution form MS, post it here and make it the Accepted Solution. Sorry I could not help.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
PedroCGDCommented:
Ok Chris!!
Regards!
Pedro
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.