Qlik MS SQL connector error "Invalid object name" when trying to load data from temporary tables

Andreas_Giesbrecht — Fri, 18 Feb 2022 10:02:54 GMT

The Qlik MS SQL connector (from the Qlik ODBC connector package) might return an "invalid object name" error when trying to reload from temporary tables, like for example:

At the same time when you try the reload via ODBC System DSN or OLE DB it works as expected:

This behavior seems to be a defect which does not occur in newer Qlik Sense version like for example May 2021 upwards.

If you still would like to use the Qlik MS SQL connector for temporary table reloads in the older Qlik Sense versions, then just upgrade the Qlik ODBC connector package version accordingly (before any upgrade please backup the original ODBC connector package version and test the upgrade on a test environment)

Environment

Qlik Sense June 2020

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

article Qlik MS SQL connector error "Invalid object name" when trying to load data from temporary tables in Official Support Articles

Qlik MS SQL connector error "Invalid object name" when trying to load data from temporary tables

Environment