Build application which connect to a sql server 2000/5/8 via GPRS

  • Thread starter Thread starter Fabio Mastria
  • Start date Start date
F

Fabio Mastria

maybe it's not possible..

but can i build an application which interfaces with a DB server and all did
via GPRS?

(using .net 2.0 or 3.5)

have you some suggest?

thank you all
Fabio
 
Yes, you can do that, if the server is accessible on the network, probably
the Internet, to which your GPRS connection connects you. What are you
trying to do? You don't want to use RDA over GPRS, I think. That is likely
to be very expensive (as well as requiring a port in your corporate firewall
to be opened for SQL Server, which makes your server data vulnerable to
attack, etc., etc.) If you are using Merge Replication, though Internet
Information Server, that's reasonably secure and, assuming that you already
have an outward-facing IIS system for your Web site, doesn't require
reconfiguration of your firewall.

Paul T.
 
You can't talk "directly" using SQL Client on the device to a desktop
database. You any of the following techniques identified by Paul although
you'd be mad to open up a SQL database on the internet.

The other method is Sync Services for devices which is currently in CTP.
This is a much better way to sync your data. Alternatively write a service,
WCF, ASMX, Sockets..to receive data, post data etc.
 
Paul said:
What are you trying to do?
Click to expand...

I write a mobile application that based on user actions create some data
files. These data have to be stored on a desktop SQL Server (2000 or 2005 or
2008).

But this operation need to be done via GPRS.

Many user with a windows mobile device, do some operations and then choose
to activate a sync to merge their own data in a centralized database which
contains data from all devices.

The centralized database is used then with an asp.net application. With this
application is possible to read data centralized and view report etc atc
 
Sounds like you need merge replication or sync services. Depending on
timescales I'd more inclined to use sync services (currently in CTP).
 
Simon said:
Sounds like you need merge replication or sync services. Depending on
timescales I'd more inclined to use sync services (currently in CTP).
Click to expand...

Ok thank you, i don't know much about sync services or CTP.... I will google
for something about it

thanks
 
Back
Top