ZappySys ODBC Powerpack is creating several registries

ODBC PowerPack
1

Introduction

The ZappySys ODBC PowerPack is widely used to connect SQL Server and other applications to REST, SOAP, and various data sources through ODBC drivers. Like any actively developed software, improvements and bug fixes are regularly introduced to enhance stability and performance.

In earlier builds, a registry management issue was identified where specific keys created during query execution were not correctly removed, leading to unnecessary registry entries over time. This behavior could cause registry bloat in environments with heavy query activity.

Prerequisites

Problem

When queries were executed using the ZappySys driver:

  1. New registry keys were created under:

    HKEY_CURRENT_USER\.DEFAULT\SOFTWARE\Classes\CLSID

  2. ZappySys created and deleted keys in a 2:1 ratio, leaving behind orphaned entries.

  3. Over time, these leftover keys accumulated, resulting in registry bloat.

Steps

Step 1: Apply the Fix in the Latest Version

The registry cleanup issue was fixed in Version 1.8.1.10901 [Sep 21, 2023].

  1. Check the version you are using; this article can help you.
  2. Download and install the latest version of ZappySys ODBC PowerPack from the official site. You can check here our release note
  3. Upgrade the driver on all affected environments.
  4. After updating, the driver will correctly clean up registry entries created during query execution.
  5. Tip: If the ODBC driver service account lacks write access to HKEY_CLASSES_ROOT, configure permissions properly, as this was a contributing factor to orphaned entries.

Step 2: Verify the Resolution

  1. Run a test query with the updated driver.
  2. Inspect the registry path to confirm that leftover keys are no longer created.
  3. If old orphaned keys remain, use safe registry cleanup methods to remove them.

Conclusion

The registry management bug in older builds of ZappySys ODBC PowerPack has been resolved in Version 1.8.1.10901. If you are experiencing registry bloat caused by orphaned entries, upgrade to the latest version to benefit from this fix and ensure optimal driver performance.

Visit ODBC PowerPack landing page for more information and download and install it to start building smarter, faster, and more scalable solutions.

References

Contact us

If you encounter any issues or have specific questions, reach out to our support team via live chat or support ticket using our email support@zappysys.com.