I have created a stored procedure in snowflake and I am calling that procedure in SSRS using odbc driver. SSRS Report is working fine in Visual Studio but while running it on ssrs server getting below error-

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Snowflake_fintech'. (rsErrorOpeningConnection)
ERROR [HY000] [Snowflake][Snowflake] (4) REST request for URL *** failed: CURLerror (curl_easy_perform() failed) - code=6 msg='Couldn't resolve host name'. ERROR [HY000] [Snowflake][Snowflake] (4) REST request for URL *** failed: CURLerror (curl_easy_perform() failed) - code=6 msg='Couldn't resolve host name'.

I’m using SnowflakeDSIIDriver and snowflake64_odbc-3.3.1 driver for snowflake odbc.

To fix that issue I have created a new system DSN on the same server and updated the DSN name with the new one data source after then reports started working fine. But whenever I made some changes in Stored procedure after then the report will again start failing with the same error.

Every time when this error is coming I have to change the system DSN in data source manually to fix that issue.