How to verify ODBC or OLE DB connections in case of connection issues with QlikView or Qlik Sense

Sonja_Bauernfeind — Thu, 25 Jan 2024 09:38:37 GMT

When troubleshooting a generic ODBC / OLE DB connection issue in QlikView or Qlik Sense, an important step is to identify whether the issue is at the ODBC driver or OLE DB provider or in the Qlik product.

Multiple third-party tools can be used to verify connections, such as DBeaver (open-source database tool), or simply Microsoft Excel. Verifying if the connection is successful with these third-party tools can verify if the issue is with the database (credentials, configuration, network connectivity), or with Qlik Sense in case of success.

For examples with Microsoft Excel, see:

ODBC: Import data from data sources (Power Query) | Support.Microsoft.com
OLE DB: Import data from data sources (Power Query) | Support.Microsoft.com

Note: It is important that Excel is installed on the same server with QlikView/ Qlik Sense, and is executed under the same account running QlikView Server / Qlik Sense Engine services or QlikView/ Qlik Sense Desktop

Environments:

QlikView all versions
Qlik Sense all versions

article How to verify ODBC or OLE DB connections in case of connection issues with QlikView or Qlik Sense in Official Support Articles

How to verify ODBC or OLE DB connections in case of connection issues with QlikView or Qlik Sense