Qlik Community

Ask a Question

Knowledge Base

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER

How to verify ODBC/ OLE DB connections using Excel

Sonja_Bauernfeind
Digital Support
Digital Support

How to verify ODBC/ OLE DB connections using Excel

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/ OLE DB provider or in Qlik product. Microsoft Excel can be used as a third-party tool to quickly test the ODBC/ OLEDB connection outside of Qlik product as follows:

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
Labels (1)
Version history
Revision #:
3 of 3
Last update:
‎2020-08-24 09:05 AM
Updated by:
 
Contributors