Hello sir,
I am trying to connect to dremio from python, i am getting error when i use this script
cnxn = pyodbc.connect(
“Driver={Arrow Flight SQL ODBC Driver};”
“ConnectionType=Direct;”
“AuthenticationType=Plain;”
“HOST=host address;”
“PORT=31010;”
“UID=uid;”
“PWD=password”
)
cursor = cnxn.cursor()
cursor.execute(“SELECT * FROM DBShift.dbshift.sample_data,accounts”)
rows = cursor.fetchall()
The error is :- cnxn = pyodbc.connect(
pyodbc.OperationalError: (‘08S01’, ‘[08S01] [Apache Arrow][Flight SQL] (500) Flight returned unavailable error, with message: failed to connect to all addresses. Please ensure your encryption settings match the server. (500) (SQLDriverConnect)’)
so help me with this…i know how to connect to dremio through DSN but i need to connect through ODBC connection.