Hive database connection with C# code

[#1]

Hi all, can you please help me in the steps to connect C# application (asp.net) with Hive database using Hortonworks hive odbc driver. Can u please provide me the steps? and connection string. Also I am using Kerberos authentication.

@Ajay Rawal

[#2]

Hi, Can you please help me to connect my C# application with hive database using hortonworks odbc driver. we are using Kerberos authentication. I am using this connection string

var connectionString2 = @"DRIVER={Hortonworks Hive ODBC Driver};

Host=host address;

Port=port number;

Schema=default;

HiveServerType=2;

ApplySSPWithQueries=1;

AsyncExecPollInterval=100;

HS2AuthMech=2;";

but getting error as "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".

Please help me if you have any solution to this! @Lucas Partridge

[#3]

We are facing dame issue, have you resolved this issue, please let us know