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

2014-01-13

Situation:
Error Message:
The Specified DSN contains an architecture mismatch between the Driver and Application
clip_image001
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]

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_image003

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










2 comments

Anonymous said...

Thx so much

Keith, NYC

Macie D said...

Grreat post thanks

Newer Older