Skip to Content
avatar image
Former Member

ODBC drivers installation in HANA express

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 30, 2016 at 09:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Jan 09, 2017 at 12:04 PM

    Hi,

    I am not familiar with the data set but from the log file it appears that table/view NME_T is looked for in the SYSTEM and STS schema.

    Could not find table/view NME_T in schema SYSTEM

    could not delete from table ""STS"."NME_T"".

    Maybe the ODBC connection requires the STS user and not SYSTEM? Maybe the code needs to set the schema first?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Denys van Kempen

      Denys,

      On a separate note. I was using .NET SAP HANA connection library (as below) for mass data loading. Is this supported for HANA Express? Sample code below/

      ///<summary>

      /// Insert data in bulk from the DataTable provided

      ///</summary>

      ///<param name="str_TableName">Schema.TableName</param>

      ///<param name="tbl_Data"></param>

      ///<param name="columns"></param>

      ///<returns></returns>

      publicbool MassInsert(string str_TableName, DataTable tbl_Data, string[] columns)

      {

      string[] name = str_TableName.Split('.');

      HanaConnection connection = newHanaConnection(_connectionString);

      connection.Open();

      HanaCommand cmd_Schema = connection.CreateCommand();

      cmd_Schema.CommandText = string.Format("SET FORMAT {0}", name[0]);

      cmd_Schema.ExecuteNonQuery();

      HanaBulkCopy cmd_Bulk = newHanaBulkCopy(connection);

      cmd_Bulk.BulkCopyTimeout = 1000;

      cmd_Bulk.DestinationTableName = name[1];

      cmd_Bulk.BatchSize = 1000;

      cmd_Bulk.WriteToServer(tbl_Data);

      cmd_Bulk.Close();

      cmd_Bulk.Dispose();

      connection.Dispose();

      returntrue;

      }

  • avatar image
    Former Member
    Jan 09, 2017 at 09:49 PM

    Thanks Denys. I was able to get this to work. It was related to default schema of HANA user.

    Appreciate your help.

    Add comment
    10|10000 characters needed characters exceeded