網頁

2013年1月28日 星期一

Microsoft Access Database Engine 2010 Redistributable --- No 64 bit ODBC Drivers in Windows 7 x64

In Windows 7 x64, the default Data Source(ODBC) will point to 64 bit DLL in “C:\Windows\System32”. If we want to run 32 bit Apps on 64 bit Windows 7, we need to use 32 bit ODBC Administrator Tool by launching “C:\Windows\SysWOW64\odbcad32.exe”. (# 1)

When we launch ODBC Data Source Administrator and want to configure Excel Files in User DSN tab,
ScreenHunter_11we get an error message “Cannot find Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) ODBC driver”.ScreenHunter_12
Although I know use the different ODBC administrator to configure 32bit or 64 bit DSN setting (#  1), I don’t when 64 bit ODBC driver for Office 2010 miss. In my intuition, the solution is very simple that reinstall ODBC driver!
So I download AccessDatabaseEngine_x64.exe from Microsoft Download Center(# 2) and double-click this file for installing it. But the warming message show up “Cannot install it besides remove the 32 bit installation of Office products firstly”.ScreenHunter_13I don’t want to follow its suggestion because it will spend more time to remove and reinstall Office.
I search Web information by Google and find out it can be resolve by adding passive switch. The full command line is AccessDatabaseEngine_X64.exe /passiveScreenHunter_16After finish the above command and redo the ODBC configuration, its function is normal now.
ScreenHunter_18
Reference :
(# 1) Unable to create DSN for Microsoft Office System Driver on 64-bit versions of Windows
(# 2) Microsoft Access Database Engine 2010 Redistributable

沒有留言:

張貼留言

Since 2010 Design by Davidwa
©Copyright Davidwa Inc. All rights reserved.