In an Asp.net application we need to query some data from Databricks. The Sql warehouse in Databricks provides an ODBC endpoint. The application we are developing will be hosted in Azure App Service, so no real access to the operating system to install any drivers.

The instructions I’ve found are either to install a driver on the server and define a DSN, or for a DSN-less ODBC connection is this:

string connectionString = "Driver={ODBC Driver Name};Server=YourServerAddress;Database=YourDatabaseName;UID=YourUsername;PWD=YourPassword;";
var connection = new System.Data.Odbc.OdbcConnection(connectionString);
connection.Open();

What should the “ODBC Driver Name” be? Databricks seems to have an own driver, but I don’t think I can install that on an App Service and haven’t found a nuget package or similar for it.