ODBC drivers installation in HANA express

[shail_verma]

I have installed HANA express using team viewer method. I need to install the ODBC driver. However I am not sure of root password. I am using SUSE Linux 12 in VMWare. Can anyone guide ?

[dvankempen · Accepted solution]

Hi,

You can find the answer to this question (and many, many more) on the SAP HANA Academy playlist for SAP HANA, express edition: https://www.youtube.com/playlist?list=PLkzo92owKnVy6nOZMFZIZxcvBCoRdshsR

Just edit the /etc/passwd file and a login shell for the root user. Using the passwd command you can set it to the value you want.

https://www.youtube.com/watch?v=gZ6xS-PXn7g&index=13&list=PLkzo92owKnVy6nOZMFZIZxcvBCoRdshsR

[shail_verma · Accepted solution]

Thanks a lot :)! I didn't see it earlier. I had one more question though no completely related.

I am able to run SELECT / UPDATE queries into HANA Express . However when I try to do an UPDATE with WHERE clause, I get the following error.

***********************************************************

OLE DB provider "MSDASQL" for linked server "hxehost" returned message "[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10210 Invalid command state (No prepared SQL command)". OLE DB provider "MSDASQL" for linked server "hxehost" returned message "[SAP AG][LIBODBCHDB DLL][HDBODBC] Base table not found;259 invalid table name: Could not find table/view NME_T in schema SYSTEM: line 1 col 13 (at pos 12)". Msg 7345, Level 16, State 1, Line 33 The OLE DB provider "MSDASQL" for linked server "hxehost" could not delete from table ""STS"."NME_T"". There was a recoverable, provider-specific error, such as an RPC failure.

****************************************************************

Would you have any recommendation for me.