SQL Gateway - ODBC Client Caching the Query/SP CALL to the external Database
Hello,
In my project, I am calling a store proc on third party database. I am using SQL Gateway and ODBC. Everything is working fine until the store proc changed. In store proc they have changed the return alias name for a column. In Ensemble Snapshot I am not seeing the modified alias name until I restarted the whole Healthshare instance.
Here is my question, is there any other way? We do not want to take the instance down if it happens after we go live.
Thanks
Raghu