I wrote a program with vs2008 which was scheduled to run in the background and scan a table held under SQL server 2017 for new invoices every few minutes. It read and updated flags on the table records once invoices had been extracted. This program ran well until Jan 2017 where it suddenly started to report the following error message:

Cannot get data from data adapter. Server={name of server running Pastel Evolution}; Database = {Database name};dsn = {Data source name defined by ODBC data source administrator}; Trusted_connection=yes;User ID=sa;

This failure is causing a huge problem on site. The program has intermittently worked and not worked since January this year. I think the failure is at the point where the program is trying to update the flag on the database table mentioned, and is somehow being denied access to update.

Can anyone suggest what might be the cause of this error and how to rectify this problem?
Thank you so much for your time.

Steve Tennett