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).