Connecting to an Oracle DB from an Office Excel file

We are trying to connect to an Oracle database inside an Excel file so that we can execute SQL statements and download data into the Excel file.
We were able to do that on several development machines but we are not having any luck on the customer's computer.
Depending on how we try to connect, we get different errors:

When using an ODBC source:
 'Test connection failed because of an error in initializing provider. [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'
We get this error when using ODBC sources created by both the 64 and 32 bit ODBC Manager tools.

When using the OLE DB Provider for Oracle:
'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. '

When we create the ODBC sources, we are able to connect to the Oracle DB (when testing the connection).

Thank you!
sbalawajderAsked:
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.

slightwv (䄆 Netminder) Commented:
On a 64Bit Windows machine there are two ODBC administrators.

If you are running 32Bit Office, you need to set up a 32Bit ODBC connection using the 32Bit Oracle Client.

https://support.microsoft.com/en-us/kb/942976

The OleDB is also likely a Bit version issue.

My guess is you installed the Oracle 64 Bit client/drivers and need the 32 Bit version.

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
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
... or vice versa.
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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 Excel

From novice to tech pro — start learning today.