>>Hi,
>>
>>Once in a while I get an email-error message which points to the application not being able to read the application .DBC file. I see this in the email error message description. It happens when the application tries to fill the Cursor Adapter (CA). Usually the code executes a SQL Select with the WHEN 1=0; that is, just getting an empty cursor. Later the application would fill the empty cursor with the data (depending on some other criteria).
>>
>>But in this case, it appears that the application (which is called from the desktop) loses connection to the server.
>>
>>What kind of a programming mechanism you recommend to either prevent it or minimize it?
>>
>>TIA
>
>I solved this problem by changing the error alert email address to point to someone who's a lot younger than I am.
>
>If that option isn't available have you tried several retries?
I like your approach of changing the email address to someone else (no matter what age).
As far as several retries, my code already does 2 tries. However, since I got the error email and analyzing my code, I see that both retries failed. Note that the problem is not caused by failure to connect to the SQL Server but failure to connect/read a file on the VM (server). I will think of other ways to reestablish the connection to the VM (when it fails).
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham