Best way to interact with SQLServer 2005 Express ?

[Peter]

Hello all,

On my device I have a Ras connection to connect to the internet.
On my home server I have SQLServer 2005 express running.
The Ras connection on the device will always be open, when it gets
disconnected it will try to make a new connection at once. (by trapping the
change event of the GPRS status)

Now I want to talk all the time with the server, polling let's say every 3
minutes or so if there is new or updated data for the device ready and send
processed data from the device back.
However for the moments that there is no internet connection availabe I want
to keep working on the device and store the data on the device for the time
being disconnected.
This data will later after reconnecting send at once.

RDA seems to me not the best way to do this... (in this case lot of Push and
Pull will be going on and empting my device tables every time)
Maybe SQLClient is an option ? (never used this on a device), but how to
store recieved data on the device ? SQLCe ? how to get the selected data
from the server in the SQLCe table ?
Or are there better ways to interact with the server database ?

Any advice, help, direction or links will be greatly appriciated to get me
started on this one!

Peter.

 

[Bruno]

hight peter

I think the best way for your problem is to use SQL server for mobile to store data in your mobile device.

You can't make réplication or diffusion with express SQL server 2005, so you have to build à program or modifie your application to request the database and record data in the mobile database.

You can use sqlclient to do that, it's work good on VS2005 and Ce5.0

Sorry for my english

Bruno from Franc

From http://www.developmentnow.com/g/18_...y-to-interact-with-SQLServer-2005-Express-.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com