#Hive odbc excel install#

#Hive odbc excel install#

You should install the version that matches the version of the application where you will be using the ODBC driver. This driver can be installed on 32bit or 64bit versions of Windows 7, Windows 8, Windows Server 2008 R2 and Windows Server 2012 and will allow connection to “WindowsĪzure HDInsight Service” (v.1.6 and later) and “Windows Azure HDInsight Emulator” (v.1.0.0.0 and later). Note: Hive ODBC Driver is a connector to Apache Hadoop Hive available as part of HDInsight clusters. Install it and add something like 'Sample Microsoft Hive DSN' as it is on my local you for posting here! I don't know if there is installed the needed driver at all. But I think this is not available at he machine where the service is running.

In the example they use 'DSN=Hive' and I use 'Dsn=Sample Microsoft Hive DSN'. The following is the connection string used: Dsn=Sample Microsoft Hive DSN applysspwithqueries=1 asyncexecpollinterval=100 binarycolumnlength=32767 caissuedcertnamesmismatch=0 decimalcolumnscale=10 gettableswithquery=0 host=…. rowsfetchedperblock=10000 uid=… password=… The following connection string works on the local machine, which indicates that this may not be a driver issue and the customer's service is setup for 32 and 64 bit. ': ERROR Data source name not found and no default driver specified' The customer is receiving an exception using C#: An Azure customer is having issues setting up a Cloud Service odbc connection string to Hive HDinsights.