Created 08-16-2017 01:33 PM
I've created a Windows 7 client application in C# that successfully connects to a Hive database using Hortonworks ODBC Driver for Apache Hive (v2.1.10). However I first had to install that driver on my machine and create a DSN which I then referenced in my application.
Instead I want to include the driver libraries directly within my application so that users of my app would not need to install the driver on their machines nor create a DSN. For example, users can connect to a PostGres database using this technique. To support that all I had to do was use Nuget Package Manager inside Visual Studio to download the Npgsql driver.
There are 32 and 64 bit versions of my app so I guess each one will have to use the 32 and 64 bit drivers respectively. The app is using .Net Framework 4 and I'm constrained to Visual Studio 2010 for now.
Created 08-21-2017 04:21 AM
Hortonworks provided ODBC drivers are available under https://hortonworks.com/downloads/. I don't see any nupkg for the current Hortorworks version.
Created 08-21-2017 08:26 AM
@Sindhu Thanks; yes, that link is where I downloaded the ODBC driver from in the first place. But do you know if Hortonworks will make their Windows drivers available via NuGet?
If Hortonworks aren't prepared to make them available on NuGet soon then I'll have to figure out which of the many dlls in the existing ODBC driver I'll need to embed in my app; or else get one of these other drivers for Hive: https://www.nuget.org/packages?q=Hive . It's just they look pretty old and many are using Thrift rather than standard ODBC to communicate with Hive.
Created 08-23-2017 09:59 AM
I've given up on this for now and am just using DSNs to attach to Hive. Hopefully one day Hortonworks will make their drivers available via NuGet so that my app can talk to Hive directly via a connection string, and not require my end-users to install the ODBC drivers themselves and configure a DSN.