WM WCF or Direct Connection to DB
|
Prev: Connect to a VPN Server (on Windows Mobile 6.1 / 6.5)
Next: error C3861: 'CeRegSetValueEx': identifier not found
From: GAS on 12 Oct 2009 06:17 Hi, i need to develop an application for windows mobile 6. My devices 2-3 are connected to the lan by wifi. I have a "server" wondows XP or Windows Vista with few Ram where is installed a WPF application and SQL Server 2008, but no IIS. Wich is the best way to exchange data form WM with SQL Server on the PC? Thanks in advance Sergio
From: Trevor on 13 Oct 2009 12:42
You can use Microsoft SQL Server 2008 on the server & Microsoft SQL Server Compact Edition 3.5 on the device to replicate data both ways. It saves a lot of coding that would otherwise be spent developing packets to move data around and putting it in the database. Both SQL Server programs will basically track changes made to the database and synchronize the changes both ways when you want your program to synchronize. The data can be one way, two ways, and you can use filters to synchronize only the data you are interested in. Windows Mobile devices will connect to IIS via HTTP/HTTPS (web synchronization) to replicate the data to/from SQL Server. "GAS" <g.a.s(a)tiscali.it> wrote in message news:O2v$jUySKHA.764(a)TK2MSFTNGP02.phx.gbl... > Hi, > i need to develop an application for windows mobile 6. > My devices 2-3 are connected to the lan by wifi. > I have a "server" wondows XP or Windows Vista with few Ram where is > installed a WPF application and SQL Server 2008, but no IIS. > > > Wich is the best way to exchange data form WM with SQL Server on the PC? > > Thanks in advance > > Sergio |