What if a connection is lost?

[bigfoot]

I have a connection from my server to my as/400. Sometimes in the middle of writing a database file, the connection is lost.
How do I make it so the as/400 does not process the 1/2 data? How do I tell my server that all of the data did not move over?

Up until now we have been going thru it by hand, because it happens so less often, but I can learn something from this. P-)

 

[Alcar]

Can you catch the exception?

Daren J. Lahey
Just another computer guy...
FAQ183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Support your forums TODAY!

http://www.tek-tips.com/supportus.cfm

 

[bigfoot]

What do you mean? Currently I am using VB6 for my application. Soon I will be moving it to .NET, I hope.

 

[Alcar]

well, with VB.NET and ASP.NET (this forum) you can catch the exception thrown by your connection object.

begin try
conn.Open()
'TO DO
end try
begin catch e as Exception
'TO DO catch the error if equal to ADODB connection error
end catch
begin finally
conn.Close()
end finally

(or something similar, I'm more a C# user)

but in your case I would suggest you connect again to the db and verify taht all the data is there with a simple select statement. Could this do for you?

Daren J. Lahey
Just another computer guy...
FAQ183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
Support your forums TODAY!

http://www.tek-tips.com/supportus.cfm

 

[bigfoot]

I think this might work ok. Will let you know.