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)β)
I think support for Arrow flight driver is not enabled yet on this instance. I suggest that you open a support ticket as there is an alternative using the legacy JDBC driver of Dremio,
[ODBC Drivers]
Arrow Flight SQL ODBC Driver=Installed
[Arrow Flight SQL ODBC Driver]
Description=ODBC Driver for Arrow Flight SQL developed by Dremio
Driver=/opt/arrow-flight-sql-odbc-driver/lib64/libarrow-odbc.so.0.9.1.168
FileUsage=1
UsageCount=1
my odbc.ini file
[ODBC Data Sources]
Arrow Flight SQL ODBC DSN=Arrow Flight SQL ODBC Driver
[Arrow Flight SQL ODBC DSN]
Description=ODBC Driver DSN for Arrow Flight SQL developed by Dremio
Driver=Arrow Flight SQL ODBC Driver
ConnectionType=Direct
Host=datahub.jp.cumulocity.com
Port=32010
UID=t21092648/*************
PWD=*******************
useEncryption=1
ERROR MESSAGE
Database error: (β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)β)
Are you really using the βArrow Flight SQL ODBC Driverβ also on Windows where ODBC access is working?
If so then
the cause of your problem is no more located on the server side (as initially when this thread had been started)
you have to check for the root cause in your RedHat configuration. However, this is at least beyond my scope: it may be an issue of ODBC cfg on RedHat, of firewall cfg, β¦