By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,402 Members | 1,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,402 IT Pros & Developers. It's quick & easy.

exception error when closing app

P: n/a
Ron
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. Is there a way I can suppress this exception
message? The app gets invoked programmatically on a
schedule. So no one would be around to click off the
error message.

Thanks
Nov 21 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
Hi,

How do you close the app? Have you tried
Application.Exit()

HTH,

Bernie Yaeger

"Ron" <an*******@discussions.microsoft.com> wrote in message
news:0c****************************@phx.gbl...
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. Is there a way I can suppress this exception
message? The app gets invoked programmatically on a
schedule. So no one would be around to click off the
error message.

Thanks

Nov 21 '05 #2

P: n/a
Ron
No. But I am pretty sure that is what I was looking for.

Thanks.
-----Original Message-----
Hi,

How do you close the app? Have you tried
Application.Exit()

HTH,

Bernie Yaeger

"Ron" <an*******@discussions.microsoft.com> wrote in messagenews:0c****************************@phx.gbl...
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. Is there a way I can suppress this exception
message? The app gets invoked programmatically on a
schedule. So no one would be around to click off the
error message.

Thanks

.

Nov 21 '05 #3

P: n/a
"Ron" <an*******@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/>
Nov 21 '05 #4

P: n/a
Ron
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" <an*******@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/>
.

Nov 21 '05 #5

P: n/a
Ron
OK. I think I fixed (I hope!). I moved the Me.Close
statement out of the DTS package procedure and into a
Timer procedure. Apparently, the DTS package is very
touchy and does not want to perform anything else that is
not part of the DTS Package. Man, I can't wait for
ADO.net2 (note: I use DTS because I am moving a few gigs
of data - daily - of course, for the test purpose, each
textfile DTS is reading only contains 100 records right
now).

-----Original Message-----
Thank you. I changed it to Me.Close. But I still get theApplication 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" <an*******@discussions.microsoft.com> schrieb:
my application is throwing an exception error whenclosing 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/>
.

.

Nov 21 '05 #6

P: n/a
What kind of package are you running? Bulk insert?
"Ron" <an*******@discussions.microsoft.com> wrote in message
news:06****************************@phx.gbl...
OK. I think I fixed (I hope!). I moved the Me.Close
statement out of the DTS package procedure and into a
Timer procedure. Apparently, the DTS package is very
touchy and does not want to perform anything else that is
not part of the DTS Package. Man, I can't wait for
ADO.net2 (note: I use DTS because I am moving a few gigs
of data - daily - of course, for the test purpose, each
textfile DTS is reading only contains 100 records right
now).

-----Original Message-----
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" <an*******@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/>
.

.

Nov 21 '05 #7

P: n/a
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" <an*******@discussions.microsoft.com> wrote in message
news:06****************************@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" <an*******@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/>
.

Nov 21 '05 #8

P: n/a
Ron
Yes, bulk insert. Originally, I was using vb6 and pulling
data from an external data source (non rdbms) and writing
each record to sql server record by record. It started
taking too long (several hours) and was becoming
unreliable, connection open too long. So with vb.net, I
read each record and write it to a series of text files
(each text file will contain at most 20,000 records). I
write close to 100 textfiles (nearly 2,000,000 records).
Then I suck em all up with DTS - takes only 2-3 minutes
with vb.net. The suggestion of using the DTS Agent is
that I have nearly 100 text files to import. I loop
through my DTS package in the vb.net app. Much easier
than using the agent. The new system takes between 1 to 1
hrs. Way more reliable because writing text files is a
snap with vb.net. Plus, vb.net runs the DTS package 3-4
times faster than vb6

But I understand that ado.net2 will have bulk insert
capabilities similar to DTS. I sure hope that is true. I
believe that DTS packages are hard to deal with because
they are basically com based, I mean I have to make a
reference to DTS package Object Library from the com tab
in references.

-----Original Message-----
What kind of package are you running? Bulk insert?
"Ron" <an*******@discussions.microsoft.com> wrote in message news:06****************************@phx.gbl...
OK. I think I fixed (I hope!). I moved the Me.Close
statement out of the DTS package procedure and into a
Timer procedure. Apparently, the DTS package is very
touchy and does not want to perform anything else that is not part of the DTS Package. Man, I can't wait for
ADO.net2 (note: I use DTS because I am moving a few gigs of data - daily - of course, for the test purpose, each
textfile DTS is reading only contains 100 records right
now).

-----Original Message-----
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 keepgetting 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" <an*******@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/>
.

.

.

Nov 21 '05 #9

P: n/a
We did something similiar at work (Bulk Insert doing about 140,000 records)
and was running through the same issues. I was originally trying to use the
BCP program and shell out to that, but became too unreliable and couldn't
manage events that would happen (out of 140,000 rows 2 would fail, I know
you can keep going but I needed to inform the user immediatly).

What we ended up doing was using the COM object for SQL DMO (I *think*
that's the library) and this worked AWESOME! Good event model on when it
inserts rows, good documentation and you run it in process so you could keep
an eye on everything going on. 140,000 records took roughly 30 seconds
doing it this way. The whole procedure took 15 minutes, 13 of that to
generate the XML file from this proprietary language called guru, 1.5
minutes for the XML DOM parser to read it in, and 2 seconds for the XSLT
transform, and 30 for the insert.

So check out the COM object, you'll find it really easy to use and easier to
debug/work with.

HTH,
CJ

"Ron" <an*******@discussions.microsoft.com> wrote in message
news:0d****************************@phx.gbl...
Yes, bulk insert. Originally, I was using vb6 and pulling
data from an external data source (non rdbms) and writing
each record to sql server record by record. It started
taking too long (several hours) and was becoming
unreliable, connection open too long. So with vb.net, I
read each record and write it to a series of text files
(each text file will contain at most 20,000 records). I
write close to 100 textfiles (nearly 2,000,000 records).
Then I suck em all up with DTS - takes only 2-3 minutes
with vb.net. The suggestion of using the DTS Agent is
that I have nearly 100 text files to import. I loop
through my DTS package in the vb.net app. Much easier
than using the agent. The new system takes between 1 to 1
hrs. Way more reliable because writing text files is a
snap with vb.net. Plus, vb.net runs the DTS package 3-4
times faster than vb6

But I understand that ado.net2 will have bulk insert
capabilities similar to DTS. I sure hope that is true. I
believe that DTS packages are hard to deal with because
they are basically com based, I mean I have to make a
reference to DTS package Object Library from the com tab
in references.

-----Original Message-----
What kind of package are you running? Bulk insert?
"Ron" <an*******@discussions.microsoft.com> wrote in messagenews:06****************************@phx.gbl...
OK. I think I fixed (I hope!). I moved the Me.Close
statement out of the DTS package procedure and into a
Timer procedure. Apparently, the DTS package is very
touchy and does not want to perform anything else that is not part of the DTS Package. Man, I can't wait for
ADO.net2 (note: I use DTS because I am moving a few gigs of data - daily - of course, for the test purpose, each
textfile DTS is reading only contains 100 records right
now).

-----Original Message-----
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 keepgetting 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" <an*******@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/>
.

.

.

Nov 21 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.