Client - Server

[alav]

How to implement a database server , in client-server local network,(we are using visual basic 6.0 and sqlserver 2000). The problem is ,if the connection is not available than we can't get the master datas from the server. If it is .net it is no problem. because it support connection less database. But if we use visual basic 6.0 , what is the way to persist the data from server after terminate the connection. Please can anybody help Thanks in Advance

[Pete OHanlon]

I think you have a bit of a misunderstanding of what connectionless means. While your program is running, data can be persisted into memory. If the application stops and restarts, then it needs to get the data again (this is simplified, and doesn't address out of process databases). While DataSets are designed to be disconnected, it does not follow that .NET is connectionless. If I open a DataReader and don't close it, then we have a connection. At some point you will need to get the data out of the database and this is where your problem kicks in. In both VB6 and .NET, if you can't get to the database because a connection isn't present then you are stuck. If you want to store the information in memory, and you can get to it, then you can use exactly the same mechanism for VB6 as for .NET, i.e. you read the data into something that exists for a period of time. It could be that you store a recordset in memory, but however you do it, at some point you will need to persist these changes back into the database server. You will need to consider the implications of stale data and optimistic/pessimistic saves.

Deja View - the feeling that you've seen this post before.