Architecture HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys, I need your opinions and suggestions

this is the scenario:

40 or more clients distributed along the city (those are like Kiosks), each one is collecting information in a DB locally (MSAccess xx) , and each one has to update a central statistics DB (SqlServer7 or 2000) located in a Server Remotely every 5 or 10 minutes, using a wireless net to access the internet at 56kb (The package to send is going to be 4Kb max per trip), this in not an online-fulltime connection, the access to the net is only made when it is necessary to update the statistics server (via modem), also it is not VPN.

Requirements:
The App on the clients have to be as light as possible cause the machines are not powerful, those clients machines are only to collect data locally and then send it to the server.


My solution so far:

* Client App: VB6 - MSAccess Or VB.NET - MSAccess (It Depends on the hardware .Net requirement)

* For communication: VB6 - Interop - Web Service - SQLserver Or VB.NET - WebService – SQLServer.

* On the server: A Web Service(s) updating the Statistics DB

My questions:

* What are the minimum Requirements (Mhz ,Ram ,SO) for a client machine running a .Net App?
* Am I on the right way or am I totally wrong, How would you make it?

Any Idea will be appreciated
Thanks,

Kenny
 
I think if you give more information about security, it might be easier for
people to help. How are you going to authenticate users? Internet is not a
very safe place, hackers might easily use the web services and send
information. You might use SSL if you are using web services.

I know a company that had a requirement close to this and they started with
COM+ and MSMQ and then .NET remoting and finally used copying XML files
using RAS and FileSystemWatcher at the server to process XML files when one
arrives. This is actually what BizTalk Server does behind the scene.

Cheers
Ali




Kenny said:
Hi guys, I need your opinions and suggestions

this is the scenario:

40 or more clients distributed along the city (those are like Kiosks),
Click to expand...
each one is collecting information in a DB locally (MSAccess xx) , and each
one has to update a central statistics DB (SqlServer7 or 2000) located in a
Server Remotely every 5 or 10 minutes, using a wireless net to access the
internet at 56kb (The package to send is going to be 4Kb max per trip),
this in not an online-fulltime connection, the access to the net is only
made when it is necessary to update the statistics server (via modem), also
it is not VPN.
Requirements:
The App on the clients have to be as light as possible cause the machines
Click to expand...
are not powerful, those clients machines are only to collect data locally
and then send it to the server.
 
Hi Ali,

The solution you say look very complicated and time consumin

You are totally right at this time I don’t know how to protect my web service. I’m going to check the use of SSL because I think Web Service is the way I should follo

Thanks Ali
 
Back
Top