Accessing data stored on a remote system

[kimbsan]

Hi,

I developed three bus ticket point of sale systems.one at the headquarter and the two at different branches.I need help on how to access sale data stored on the two remote systems using the main system at the headquarter.
I request for some tutorials,sample codes or complete project for review.

Thanks in advance

KIMBSAN

[WingedPanther]

Have all the branches store their data in a central database. Problem solved.

[kimbsan]

Thanks,
can i have that solution(source code or tutorial)

[WingedPanther]

It's not a solution in the sense of written source code, it's a strategy that makes it easy. Do NOT store the data in files on individual computers. Have them all store their data in one database on a single server. To implement this type of solution, you will need to learn SQL, know how to access a database from VB, etc. There is a LOT of work involved in implementing it. If you already have data at the three sites, you will also need to load that data into the database so that it's available moving forward.

This isn't a major change to your application, just to how you store the data within your application for other uses.

[kimbsan]

HI MR. WINGEDPANTHER

Thanks for the reply, and thats exactly what i wanted but the truth is that am still an amature/young in vb6.0.
so i don't know how to go about it though i can access a database using SQL commands.the challenge i got is implementing it.
pliz you can help with a tutorial on how to go about it.

Thanks in advance

[questionspoint]

if your branches have the internet facility then its very simple for you. simply create a webservice at the headquarter ( you can find help on creating web service ) and host it at the head quarter.
make your branches connect to the headquarter to update their data.

if your branches do not have the internet facility. then you will have to store individual branch data locally / offline and update it at the end of day using telephone line or by conecting to internet once a day. that will synchronize it.

[WingedPanther]

1) I'm not a VB coder... at all.
2) Some of the details will depend on whether you are using an ADO connection, a native ODBC client, or a direct connection. The type of database will also vary.