Analysis for Office (32Bit), Windows 7 (64 Bit), HDBODBC32 connectivity
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 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.