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

Question

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

Answer 1

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

 

Generally, 32 bit application should not have any problems connecting to a 64 bit SQL Server on the same machine. /p>

Are you sure you are running a 32 bit (***NOT 16 bit****) application..?

FYI...16 bit app will not work in x64 bit enviornment.

 

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

Answer 3

Surfing around for a different item, but saw this.  I had this probelm as well awhile back.  If you are using IIS as well make sure your APPLICATION POOLS are sre set right.  And if you are switching between 64-bit and 32-bit, make sure you either disable or enable 32-bit application support in the pools.

hope that helps some one with this error someday.

---

Greg

Answer 4

Thanks, Greg.  This helped me ALOT.  I was going crazy trying to understand why the ODBC driver was giving me that message.

Answer 5

Many Thanks, Greg. it in DefaultAppPool, found in IIS > Application Pools

Regards

Praveen

Answer 6

Hello greg.. I also got that type of message that "The Specified DSN contains an architecture mismatch between the Driver and Application".. but I can't understand about APPLICATION POOLS..

I am using HP Laptop with windows 7, 64 bits.. please help me.. 

I can't find help from anywhere.. you can send me mail on [e-mail]

Thanks..

Nikunj

Answer 7

Surfing around for a different item, but saw this.  I had this probelm as well awhile back.  If you are using IIS as well make sure your APPLICATION POOLS are sre set right.  And if you are switching between 64-bit and 32-bit, make sure you either disable or enable 32-bit application support in the pools.

hope that helps some one with this error someday.

---

Greg

I didn't understand about APPLICATION POOLS Greg.. Can you help me in that?? I have same problem.. 
Thanks,

NIkunj