Dear All,
I am reaching out to seek assistance regarding an issue we are encountering while attempting to establish a connection to the Dremio Data Lake House. Our setup involves a Posit Workbench hosted on a RHEL 9 Linux server, while the Dremio client is hosted on an EKS within the same AWS account.
We have followed the instructions provided in the official Dremio Admin Guide to download and set up the Arrow Flight SQL ODBC Driver. Despite configuring the connection details such as HOST, UID, PWD, PORT, and Database name, we encountered the following error message when trying to establish a connection from the R console of the workbench:
"Apache ArrowFlight SQL (500) Flight returned unavailable error, with message: failed to connect to all addresses. Please ensure your encryption settings match the server."
To troubleshoot, we verified the network connectivity through various commands like telnet, ping, nslookup, and openssl s_client, all of which indicated that connectivity is functioning correctly. Additionally, we successfully connected using the isql command by placing the connection parameters in the /etc/odbc.ini file and were able to list the tables in the Linux terminal.We were also able to connect the same from RHEL 7, AL2 Server's R Terminal
However, the issue persists when attempting to connect via RStudio IDE or using a Python script, resulting in the same error as encountered in the R console and when we try connecting from R terminal.
We are utilizing the latest version of the Driver and would appreciate guidance on enabling logs for this particular ODBC driver to gain further insights into the issue. Any assistance or suggestions to resolve this error would be greatly appreciated.