link vb program to database on another compu

March 6, 2011 at 08:05:51
Specs: Windows XP
i created a program that records the log in and log out of a user and save it in a database. it perfectly run in my computer but what if i will put the program to another computer and the database to another computer in a network, how will i do that in vb6?

See More: link vb program to database on another compu

Report •

May 25, 2011 at 07:24:47
The way i have done this (may not be correct) but what i have done is write a client and server side application. The main application (server) will connect to the client application via WinSock.

The client app will be installed on the same machine as the DataBase

The server once connected to the client will send the appropriate instructions to the client application, and the client will then update the DataBase.

Report •

May 25, 2011 at 08:00:49
That's one way fo doing it. Another much simpler way is to map the drive with database on to the computer with the application and use the mapped drive in exactly the same way as you would a local drive.

VB6 has function to automatically map a drive when it is needed and delete the mapped drive when it is finished with it.

Which way you chose is dependant on whether you want multiple access to the database. The first method would be better for multiple access as it generates relatively little network traffic.

The second way, although simpler would create a lot of network traffic if more than one person is using the database at any one time. Assuming you are using MS Access which is a multi user database that is supposed to accommodate 10 concurrent users, it does tend to get very sluggish after three.


Report •

Related Solutions

Ask Question