Error Message:
The Specified DSN contains an architecture mismatch between the Driver and Application

If you go to the ODBC Data Source Administrator, you will see the windows like this
There is only one component exit, other are gone
![clip_image001[6] clip_image001[6]](http://lh5.ggpht.com/-319vduyzJ2c/UtRujUWrhdI/AAAAAAAABsE/BNwJCCwCRhM/clip_image001%25255B6%25255D_thumb%25255B2%25255D.png?imgmax=800)
Solution:
S1:
That’s because of your OS is 64bits
Go to Control Panel -> ODBC Data Source Administrator, right click -> Properties
![clip_image001[8] clip_image001[8]](http://lh4.ggpht.com/-iMGLb1TaCX4/UtRukyEUkGI/AAAAAAAABsU/VM94lJrp4bk/clip_image001%25255B8%25255D_thumb%25255B1%25255D.png?imgmax=800)

S2:
1. Download and run AccessDatabaseEngine_x64.exe
(http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en)
2. Change the connection string :
EX: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=xxxx;Driver={Microsoft Access Driver (*.mdb)};
replaced to be
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=xxxx;Driver={Microsoft Access Driver (*.mdb, *.accdb)};
Some Server Connection Strings don’t need add “*.accdb”, I don’t know why, but for in case, add it
1 comment
Thx so much
Keith, NYC
Post a Comment