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

Giorgio De Luna Almeida 1 Reputation point
2021-04-12T15:16:31.283+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,758 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,856 Reputation points
    2021-04-13T05:17:57.143+00:00

    Hi @Giorgio De Luna Almeida ,

    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.

    0 comments