question

GiorgioDeLunaAlmeida-0569 avatar image
0 Votes"
GiorgioDeLunaAlmeida-0569 asked CarrinWu-MSFT edited

The specified DSN contains an architecture mismatch between the Driver and Application

Hi,

I'm trying to run a query into excel and received this message error

The specified DSN contains an architecture mismatch between the Driver and Application

my Windows 10 64 bits, on odbcad32 and 64 I configured the Oracle driver but still the same error, any ideas?

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Excel + Oracle Driver? Where does SQL Server come into the equation? I mean, you tagged this for SQL Server?

0 Votes 0 ·

Hi @GiorgioDeLunaAlmeida-0569, we have not get a reply from you. Did any answers could help you? If there has an answer helped, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @GiorgioDeLunaAlmeida-0569,

Welcome to Microsoft Q&A!

Sorry, I am not very clarify with your question. Are you mean you try this with SQL Server and Oracle, both failed? If yes, you will get this error if you attempt to do the following on a 64-bit Windows machine:
1.Connect a 64-bit application to a data source for a 32-bit ODBC driver.
2.Connect a 32-bit application to a data source for a 64-bit ODBC driver.

To resolve this, please refer to Managing Data Sources to get more details. If I have misunderstanding your question, please feel free to let me know.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.