strange problem

  • Aoa. Im new to sql server 2005 and Visual Basic 2008. Actually i have developed an application. On every form in vb program i have put formclosed event to update a field value which is bound with dataset while form is closed. This is working perfect, but problem is that if my application crashes or system restarts while electricity shutdown, formclosed event doesn't execute. so what to do to cope this problem......

    is there any way in vb 2008 to solve the problem???

    or any script in SQL Server 2005 that detects that particular illegally closed application and update that value which was the duty of vb application to update.

    Is there any way in Sql Server 2005 that I can check the status of client connection whether the connected vb application is running or crashed. if crashed then update a particular table's field value.

  • duplicate post. No replies please.

    Please reply here: http://www.sqlservercentral.com/Forums/FindPost1116605.aspx



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply