Link to home
Start Free TrialLog in
Avatar of sbalawajder
sbalawajder

asked on

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!
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.