Getting the below error in Prod
OLE DB provider “DBAmp.DBAmp” for linked server “SALESFORCE_LS” returned message “Error 5103 : Error: Zipped response from salesforce was missing valid zip header.”. [SQLSTATE 01000]
Hi @Pralayankar
This error stems from a recent change that Salesforce has made on their side in how they respond to certain API calls, in a way that the older pre-v22 DBAmp cannot handle. This is part of their Winter '26 release, and the fix for this issue is to upgrade to the latest version of DBAmp.
Download DBAmp: https://www.cdata.com/download/getfile.aspx?file=free/AFGH-A/setup.exe&name=CData%20DBAmp&tag=Download-dbamp
For more details about upgrading you can refer to the docs: DBAmp - Installing and Configuring DBAmp
You can find release notes here to see what has changed with this version: DBAmp - Release Notes
Note that the two versions have a different syntax to their serial numbers - you will want to make sure you have your v22+ serial number for this installation
If you have any other questions, don’t hesitate to reach out to support@cdata.com , and one of our CData DBamp support specialists will further assist you.