Skip to main content

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Sonja_Bauernfeind
Digital Support
Digital Support

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

Last Update:

Jan 25, 2024 4:38:37 AM

Updated By:

Sonja_Bauernfeind

Created date:

Sep 16, 2018 6:19:12 AM

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:

User-added image

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
Contributors
Version history
Last update:
‎2024-01-25 04:38 AM
Updated by: