Data Connection failed with error: Bad Status: Unrecognized response with no error message header

[Elena1990]

Hello everyone!

I am facing an error, while connecting to Databricks notebook

[DataSource.Error] ODBC: ERROR [08S01] [Microsoft][Hardy] (115) Connection failed with error: Bad Status: Unrecognized response with no error message header. Status code: 502. .

Before that I had error that said that spark.driver.maxResultSize is not enough, so I configured it too 300g.

Does anyone knows how to fix this?

Thank you!

[amitchandak]

@Elena1990 , can you check if the connection details are correct? Also is the ip properly whitelisted

Check if needed

https://youtu.be/AWTDEQCoOVw