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

[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

 

[Paul G. Tobey [eMVP]]

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.

 

[Simon Hart [MVP]]

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.

 

[Fabio Mastria]

What are you trying to do?

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

 

[Simon Hart [MVP]]

Sounds like you need merge replication or sync services. Depending on
timescales I'd more inclined to use sync services (currently in CTP).

 

[Fabio Mastria]

Sounds like you need merge replication or sync services. Depending on
timescales I'd more inclined to use sync services (currently in CTP).

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

thanks