How do i design Vb applications with a functionality for working in a client/server environment? What I mean is that the application has to be packaged and deployed on a client machine which has to link with a remote database on another machine.

What is the exact logic for achieving this?

Look into Winsock component tutorials for visual basic. Determine a protocol, you will probably use TCP/IP or UDP in most cases. I've written chat applications in both protocols using VB6. You can package the client and server code together or seperately, personally, I'd package them seperately.

You basically will specify the protocol and bind a sending/receiving port on a client and server ip address, you may want to have these defined dynamically. Using the DataArrival event and similar functions you can establish two way communication between client and server.

The database, for the most part, will only be relative to the server. Just connect the database with DAO or something similar and store your SQL commands in a string.... when a packet is received you parse it and determine what function to execute based on a pre-defined packet identification system...

I could go on forever, but to get a more detailed (step-by-step) answer... look into the winsock control for VB6.

IR

lombe,
if all you want to do is connect to a remote database (technically not a client/server vb app, but rather a client/server environment) then all you need to do is establish a connection to that database.

All you need to do is either use ODBC connectivity or create a connection string that you use with an ADODB.Connection to establish a link to that db.

Chi Happens