I have a multi user client server application. I am using Visual Basic 6.0 as a front end and Oracle 8i (Enterprise Edition) as server. I want the data to updated directly to my server, which is connected to the client machine over a private 64 Kbps telephonic leased line.
I am also having Oracle 8i (Workgroup Edition) at my client. The is if due to some reason the leased line is down the data should be saved at client machine.

How should i connect to the server database ?
How should i transfer the data directly from client database to the server database as soon as the leased line is up?