What does "DTM3102: Failed to connect to the underlying database" mean?

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

0 Comments

Please sign in to leave a comment.