OBIEE A B C: ODBC Problem: Excel & OBIEE 11g on Windows

I want to use an Excel worksheet as a source on my Windows 7 x64 laptop. I have OBIEE 11g (11.1.1.6.2 BP1) installed and MS Office 2010 32-bit.

So I first setup the ODBC source, using the 32-bit version of the ODBC Administrator tool, since I have MS Office 2010 32-bit installed. From: http://support.microsoft.com/kb/942976

A 64-bit version of the Microsoft Windows operating system includes the following versions of the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe):

The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.
The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.

(Confusing…)

Done.

Through the OBIEE 11g Admin Tool (11.1.1.6.2 BP 1), I can import ODBC Excel metadata.

After deploying it through Enterprise Manager however, OBIEE 11g BI Server does not like the 32-bit Excel ODBC driver, as the Answers request below shows. (This driver comes bundled with MS Office 2010 32-Bit)

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application. (HY000

So the solution is to install the 64-bit Microsoft Access components?

Unfortunately not …

What is the solution?

Perhaps this ?

Use the /passive parameter to force install of the 64-bit ODBC drivers:

AccessDatabaseEngine_2010_x64.exe /passive

Add ODBC source to 64-Bit ODBC with same DSN name:

%systemdrive%\Windows\System32\odbcad32.exe

Refresh request page:

Voila. Hardly elegant, but at first glance this works…

Useful Links -

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/abf34eea-1029-429a-b88e-4671bffcee76/#b6deab32-c1e0-436d-b783-8a4948ff99ec

http://spotfirecommunity.tibco.com/community/Themes/leanandgreen/Forums/viewIphoneThread.aspx?PostID=4863

First glance, was not enough … next time you open Excel:

Warning: This occurs every time you open Excel, Word, and breaks my Xobni add-in to Outlook! This approach effectively breaks your existing Office 32-bit install.

Fortunately, at first glance, my Answers request still works -