
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Qlik QDBC Connector package from QlikView got installed on a Qlik Sense system by mistake.
Nov 24, 2022 3:21:27 PM
Nov 24, 2022 3:21:27 PM
Qlik Sense comes with a bundled version of the ODBC connector packages. There is no need to install the Qlik ODBC connector package in those installations. If that happened here is a way to role back the change.
The Qlik Sense bundled drivers are installed in
C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage\
while the Qlik ODBC package is installed in
C:\Program Files\Common Files\QlikTech\Custom Data\QvODBCConnectorPackage\
Environment
- Qlik Sense all versions
Resolution
1.) Uninstall the Qlik ODBC connector package for Qlikview.
2.) The Registry entries under
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
and
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Qlik
need to point to the correct folder for the drivers again. Otherwise you will see the message [Error IM002][Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified.
3.) Open Windows Explorer and navigate to
C:\ProgramData\Package Cache\
4.) Search for ODBC.msi.
5.) Right click the ODBC.msi and select "Repair".
6.) When completed all is fixed and you can continue work, no service restart is needed.
Cause
Qlik Sense comes with the ODBC connector Package bundled in the installation. If you install the Qlik ODBC package on top of it you will have two issues.
- an upgrade might not replace the internal drivers, since the checksums are different
- your configuration files for e.g. Oracle need to be added in different folders.