Home » SQL ServerRSS

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

I am running sqlserve 2005 on window7 64bit and when i tried to access the database through an app, I get the error below.

SQLException caught = [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

 

2 Answers Found

 

Answer 1

Should have asked in Data Access forum... You may get better answer there

>>The specified DSN contains an architecture  mismatch between the driver  and Application

If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message:

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

To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN.
For more info
 

Answer 2

On the side note, what odbc interface you used to create connection

To manage a data source that connects to a 32-bit driver  under 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe. To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe.

If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message:

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

To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN.

A data source associates a particular ODBC driver with the data you want to access through that driver. For example, you might create a data source to use the ODBC dBASE driver to access one or more dBASE files found in a specific directory on your hard disk or a network drive. Using the ODBC Data Source Administrator, you can add, modify, and delete data sources, as described in the following table.

http://msdn.microsoft.com/en-us/library/ms712362(VS.85).aspx

 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter