Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive database connection with C# code

Hive database connection with C# code

New Contributor

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

1 REPLY 1

Re: Hive database connection with C# code

New Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here