Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Analysis for Office (32Bit), Windows 7 (64 Bit), HDBODBC32 connectivity

Hi Experts,

as title mentioned, we use Windows 7 (64 Bit) and MS Office 2010 (32 Bit). I want to connect with Analysis for MS Office (we use the latest Patch 10 from decemder 2014) and Hana directly - the local Option.

I read the blogs System ODBC connection to Hana viewable in Analysis for Office and Using Design Studio with SAP HANA end to end-Part 1 and Design Studio 1.0: Connect to SAP HANA .

I installed the HDB Client and then I make a ODBC connection in the Administration Console from Windows. As mentioned I use the 32 Bit one with the prompt " %windir%\SysWOW64\odbcad32.exe " in the comand line. After this I follow the steps to create a new ODBC Connection. I wondered because I didn't had the option HDBODBC32 - so I choose the SAP HANA for MS Excel Option. I tested it with the option connect and all works fine. Then I startet Analysis for Office and skip the first Option so I get the local mode to connect a SAP BW oder even HAN. But my Connection I created is still missing.

When i try this with the 64Bit Version of the ODBC it works in the ODBC Administration console and when I start Analysis I see the HANA connection, but it didn't works because this is the wrong ODBC connector (64Bit)

I'm frustrated, because I just tried the connector with Design Studio, and the 32Bit ODBC Connector is displayed and it worked all fine.

Does anybody can help?

In attach you can see the screenshots from the ODBC Administration Console.

Regards Toni

odbc_02.JPG (53229 B)
odbc_01.JPG (42046 B)
odbc_admin.JPG (62151 B)
Former Member
Not what you were looking for? View more on this topic or Ask a question