Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

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

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Andreas_Giesbrecht

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

Last Update:

Feb 18, 2022 2:02:54 AM

Updated By:

Andreas_Giesbrecht

Created date:

Feb 18, 2022 2:02:54 AM

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:

Andreas_Giesbrecht_0-1645178274648.png

 

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

Andreas_Giesbrecht_1-1645178330976.png

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.

Contributors
Version history
Last update:
‎2022-02-18 05:02 AM
Updated by: