IDT Rel Conn why no create HANA database connection

[glen_spalding]

hi all

for some reason, I cannot create a relational connection in the IDT when I go to

File->New->Relational Connection->SAP->SAP HANA Database 1.0->ODBC Drivers

there is no Data Source Name available for selection, HOWEVER

if I go to

File->New->Relational Connection->Generic->Generic ODBC Datasource->ODBC Drivers

this picks up my 32bit DSN without any problems

what is the difference ?

thanks

g

[Former Member · Accepted solution]

Here how to create a HANA 32 bit ODBC connection:

http://scn.sap.com/community/businessobjects-design-studio/blog/2013/06/16/using-design-studio-with-...

[glen_spalding]

thanks to every one, i finally realized that the Excel 32 drivers are not the same as the HANA DB 32 bit drivers !!

what a mess

g

[former_member185603]

Did you install Hana client? Did yous etup ODBC driver based on Hana or Generic ODBC?

[glen_spalding]

Yes, HANA Client is installed, otherwise I would not be able to use the Generic ODBC, wouldn't I?

also HANA Client does not enable me to choose anything, it all goes in. ODBC, JDBC, etc...

it is the HANA driver route that does not find my DSN, not the Generic route. see the path I mentioned

thanks

g

[former_member185603]

You need to create ODBC drivers on HANODBC, not on generic. If you have installed Hana client, you will see an option to select the HDBODBC while creating ODBC driver.

[glen_spalding]

hi, firstly, don't think i can use ODBC DSN was created using HDBODBC as this is a 64bit driver.

so my 32bit DNS was created using the "SAP HANA for MS Excel", which is 32bit - LIBODBCHDB32.DLL

Maybe, this driver is not good for creating connections in IDT!?!?!?

what is the name of the Driver you have ?