If you see the error message "DTM3102: Failed to connect to the underlying database" when trying to connect to Hyper-Q, it means that Hyper-Q was unable to connect to the downstream database using ODBC drivers. The error message contains details from the error provided by the ODBC stack. For example, a complete error message can look like this:
DTM3102: Failed to connect to the underlying database: "[unixODBC][Driver Manager]Can't open lib '/usr/lib64/psqlodbcw.so' : file not found SQLSTATE IS: 01000 Connection to database failed." (odbc_beta:285)
The detailed error message provides additional information about the problem. Ensure that:
- the ODBC driver for the downstream database is working correctly on the host running Hyper-Q
- the system
odbcinst.ini
file has been copied to Hyper-Q'sconfig
directory - the
connection_string
property in Hyper-Q's configuration filedtm.ini
matches the driver - the credentials provided in the client application are valid on the downstream database
0 Comments