Missing HDBODBC driver

[Former Member]

Hi,

We have installed 32 bit HANA client and added new system.

Now we are creating Datasource for HANA using DI.

We are doing

1. Start >> Control panel >> Administrative Tools

2. Choose DataSources (ODBC)

3. Choose System DSN

4. Choose Add

Here we need to select HDBODC driver from the list, but this driver is missing in the list.

Have we missed anything? What we need to do to get this driver?

Thanks & Regards

Sagar Shelar 

[hai_murali_here]

Hi,

Install the HANA Client in your system where you try to configure the ODBC Connection.

The command to be used ....__installer.HDB\hdbinst.exe -a client

Rgds,

Murali

[Former Member]

Hi All,

Thanks for the replies.

Actually we have 32 bit windows and we have installed 32 bit HANA Client on Win 32 OD vresion.

But still we are missing this HDBODBC Driver in the list.

In one of the posts I found that we need to install HANA client on BODC server, this will add HDBODBC driver on the Drivers tab.

Is that what I'm missing? Do we need to install HANA client on BODS server?

Regards

Sagar

[Former Member]

Yes, if you are running BODS designer from a different client machine to that of the BODS server, yes you need HANA client to be installed in both. However, I am not too sure if that is why you are missing HDBODBC here but may well be. Since you need to do it anyway, I think you should try it out straight away and please update it here if that solves it for the benefit of others.

Thanks,

Anooj

[Former Member]

Make sure you are using the 32bit ODBC Administrator to create your connection.

The 32bit ODBC admin is run from C:\Windows\SysWOW64\odbcad32.exe

The 64bit ODBC admin is run from C:\Windows\System32\odbcad32.exe

The 32 bit driver will show up in the list of available drivers as HDBODBC32.

Cheers,

Jody

[Former Member]

Dear All,

Thanks a lot for your help.

We installed HANA client on BODS server and it solved the issue.

Thanks & Regards

Sagar Shelar