[SQL] Microsoft Access Error “3146 ODBC-Call Failed”, While trying connect to SQL

Situation:
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


Solution:
S1:
That’s because of your OS is 64bits
Go to Control Panel -> ODBC Data Source Administrator, right click -> Properties



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