Client Server

[Victoria]

Can anyone help?

Hi, I'm Victoria,

I'm trying to create a client server program in VB to allow the number of customers entering a shop per hour to be stored in a database and then the information to be retreived by another user. I'm struggling a bit. First-timer to this site so I'm not sure how it works.

Yours Victoria.:cool:

[Sastraxi]

Is the shop online or real?

(real being that it would have an electric circut running from the door to a card that goes into your comp, and then reading it there)

In case you mean online, you can store the value in an application level variable, when Session_OnStart fires. When the app. starts (application_onstart) you can get the time & store it in app. level variable. Then after your hour is up, you can write it to a database using the ADODB.Recordset & ADODB.Connection objects. Then to retrieve use the same objects.

If you would like me to elaborate I could probably whip out some code.

[Victoria]

Thank you so much for getting back to me. It's much appreciated.

Our problem spec is as follows:

We require to know the number of customers entering each store every hour. This will enable the effectiveness of each store to be monitored centrally and to ensure that safety considerations have been catered for.

A Mechatronics Engineer has been allocated to manage the data acquisition side of the project. The Engineer will be responsible for commissioning the I/O board and the sensors on a PC in each store and will also write the Visual Basic code to handle the acquisition of the data.

We need Visual Basic programs for both the clients and the server which will allow the transmission of the number of people in the store every hour to a central server. The PC in each store will be equipped with a modem which can connect to the Internet (the IP address will be allocated dynamically i.e. it is not a fixed IP address). Both the client and server should store all data in a Microsoft ACCESS database and the server side should include facilities for analysing the data.

Assume that the central server has a fixed IP address.

The programs should be designed to minimise data loss and delivery errors.

Can you help? A bit behind with the deadline for this and have a meeting! Can't get my code to link up.

Yours hopefully,

Victoria.:)