- We have installed Dremio ODBC drivers set on Linux OS.
- [Dremio ODBC Driver 64-bit]
Description=Dremio ODBC Driver(64-bit)
Driver=/opt/dremio-odbc/lib64/libdrillodbc_sb64.so
UsageCount=1 - created a custom DSN name [DremioSIT].
- Question: How to test the Dremio DSN name in Liunx. For example, For MS SQL, we use isql
- We are using SAS 9.4 Server version to connect to Dremio Server through SAS EG client tool and received the below mentioned error.
<<
1 %_eg_hidenotesandsource;
5 %_eg_hidenotesandsource;
WARNING: Unsupported device ‘ACTIVEX’ for PDF(EGPDF) destination. Using device ‘ACTXIMG’.
48
49 options sastrace=‘,ds’ sastraceloc=saslog nostsuffix;
50 libname dsit ODBC dsn=“DremioSIT” user=“1555920” password=XXXXXXXXXXXXXX;
ERROR: CLI error trying to establish connection: [unixODBC][Dremio][Connector] (1000) Unknown error occurred while trying to
connect.
ERROR: Error in the LIBNAME statement.
51
52
53
54 %_eg_hidenotesandsource;
66
67
68 %_eg_hidenotesandsource;
71
Please suggest