Database connectivity
Hi
I am using ado in Vb and sql server as backend.
I need to enhance error handling in my project. Right now if the client(vb project) looses its server object (can occur if the DB server is rebooted while application is running) and they try and continue using vb project, the infamous Invalid Object or Method error.I have handled it with msgbox.
But Requirement is even though connection is lost and some time when it will be restored , if user starts working on application it should continue.
Can anyone help me in this.
Thanks,
Vidhi
[582 byte] By [
Vidhi] at [2007-11-11 8:45:21]
# 1 Re: Database connectivity
What functions does the application perform when the connection is available?
And what functions can the app. perform when the connection is NOT available?
# 2 Re: Database connectivity
When connection is available user can access all the functionalities. But when connection is lost it should give message saying that connection is lost. But when connection with db is restored and after that whatever user tried to perform it should work normally the way it was before connection was lost. no need to close the application n repoen it to get the db connectivity once again.
Thks
Vidhi
Vidhi at 2007-11-11 17:26:01 >
