DTM3102: Failed to connect to the underlying database

Problem

Hyper-Q reports the error message DTM3102: Failed to connect to the underlying database.

Cause

Hyper-Q was unable to connect to the backend database using the ODBC drivers.

The error message contains details from the error provided by the ODBC stack. For example, a complete error message may appear as:

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.

Solution

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 the Hyper-Q config directory.
  • The connection_string property in the Hyper-Q configuration file (dtm.ini) matches the driver.
  • The credentials provided in the client application are valid on the backend database.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.