The specified DSN contains an architecture mismatch between the Driver and Application-Error in VB

When connecting MS Access/ My Sql database in C# with the VB it shows an error,  "ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". Here you can solve the problem.
This is due to the mismatch of the bits of your PC, OS and the ODBC Driver. If you are on windows 7 you can see the drivers installed on you PC in the control panel ODBC administrator.
Start > Control Panel > ODBC administrator.
But for some reasons the whole list may not be appear there, thus use the following solution.

Creating Access ODBC datasource in Windows 7 (64bit)

  • First of all you just go to below path
C:\windows\sysWOW64
  • There you can see an executable entitled odbcad32.exe. You need to run this exe as administrator to access to all the ODBC drivers that come with Microsoft Office, MySql etc.
You can also open the ODBC Administrator location Pasting the below path in the Run
C:\windows\sysWOW64\odbcad32.exe
Enjoy programming...Good luck.
If you like this please like and follow us at the right.

1 comment: