Re: exception error when closing app

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bernie Yaeger (berniey_at_cherwellinc.com)
Date: 10/23/04


Date: Fri, 22 Oct 2004 20:36:59 -0400

Hi Ron,

I run DTS packages through the sql server agent. It runs the package and
closes itself without incident. I see that you may have the problem solved,
so that's what counts; but if you don't, you may want to use sql server's
server agent for this.

HTH,

Bernie

"Ron" <anonymous@discussions.microsoft.com> wrote in message
news:061f01c4b887$25bb8ac0$a601280a@phx.gbl...
> Thank you. I changed it to Me.Close. But I still get the
> Application error when I invoke the app from another app.
> The error is
>
> Application Error
> The instruction at "0x7923302d" referenced memor
> at "0x00219404", the memory could nto be read".
>
> I am running a DTS package from vb.net. I was having
> problems running the package from the original app so I
> created a separate app that I start with
> system.diagnostics.process.start(app, args) from the
> original app. The 2nd app only runs DTS.
>
> Then the DTS app is supposed to close itself. But I keep
> getting the error above when I run the DTS package
> procedure. If I don't run the DTS package then the DTS
> app closes correctly. Note: the DTS package runs fine,
> but something is getting set by the DTS procedure at the
> system level. I wish I knew what it was so I could
> reset it.
>
> Ron
>
>
>>-----Original Message-----
>>"Ron" <anonymous@discussions.microsoft.com> schrieb:
>>> my application is throwing an exception error when
> closing
>>> if I run a procedure in the app. I can't even trap the
>>> error with try/catch ex As Exception. Is there a way to
>>> completely shut down the app through code? I am using
>>>
>>> End
>>>
>>> for now.
>>
>>What exception?
>>
>>Notice that 'End' or 'Application.Exit' is not the best
> choice. Instead,
>>simply close the main form by calling its 'Close' method.
>>
>>--
>>Herfried K. Wagner [MVP]
>><URL:http://dotnet.mvps.org/>
>>
>>
>>.
>>



Relevant Pages

  • Re: export access to sql server
    ... i followed article from sql server books MSDN. ... Running a DTS Package Saved as a Visual Basic File ... Actually my software will support access ... If the app needs to dynamically recreate the ...
    (microsoft.public.vb.general.discussion)
  • DTS pkg only runs once in my app?
    ... in my vb.net app I run a DTS package from a button. ... with a static integer var. ... is it possible to re-run a DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: exception error when closing app
    ... Application error when I invoke the app from another app. ... I am running a DTS package from vb.net. ... problems running the package from the original app so I ...
    (microsoft.public.dotnet.languages.vb)
  • Re: exception error when closing app
    ... the DTS package is very ... >Application error when I invoke the app from another ... >problems running the package from the original app so I ...
    (microsoft.public.dotnet.languages.vb)
  • Package fails when run from Sql Server Agent
    ... I have a stored procedure that createz a DTS package on the fly using ... Step error code: 8004206A ... What would cause some rows to fail when using Sql Server Agent? ...
    (microsoft.public.sqlserver.dts)