Re: SQL Server CE on PPC, mdb on Desktop pc; how is it possible to exchange data ?



It's really not. You could use SQL Compact on both the desktop and the
device (SQL Compact 3.5 -- see www.microsoft.com/downloads), or you could
use one of the server versions on the desktop and use either RDA or Merge
Replication on the device. You need to give up on Access though; there's no
support for this at all, at least from MS, any more.

Paul T.

"Newcomsas" <newcomsas@xxxxxxxxxxx> wrote in message
news:fu7uji$j2h$1@xxxxxxxxxxx
Hello.
I'm facing a problem about the interaction between desktop Pcs and
palmtops that apparently is not documented.
I have got a C# device application running on a PPC with Windows Mobile 5
and SQL Server 2005 CE. I would like to establish a connection with an
access database located on a destop PC. Is there anyone who knows if and
how this is feaseble ? I can use indifferently ActiveSync or Bluetooth to
link the two elements; is it anyway possible to launch the connection
directly from the C# application ?
Once the connection is established I should be able to copy a couple of
tables from Access to SQLCE and a table back from SQLCE to Access.
I would like to add that I'd prefer to avoid the use of a web service to
make the system work.

I thank you in advance for any help.

Newcomsas



.



Relevant Pages

  • Re: XML Virtual Memory Issue?
    ... open a connection to sqlce on the PPC ... every time you read an IDataRecord from the server write it to CE! ... > We write the XML to a dataset and then populate a SQLCE DB from the XML ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot connect client to server 2003
    ... you need to reconfigure the IP schema of your SBS ... On the SBS 2003 Server open the Server Management console. ... On the Connection Type page, click Broadband, and then click Next. ... Alternate DNS server, type the IP addresses that are provided by your ISP ...
    (microsoft.public.windows.server.sbs)
  • Re: Outgoing POP3 email missing/lost/not received
    ... ISP's mail server instead of the domain name on the ... SUMMARY OF SETTINGS FOR CONFIGURE E-MAIL AND INTERNET ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Networking Question - VLANs on SBS 2003 Premium SP1
    ... port on the old router so I now have a segregated WLAN. ... be sure you do not enable any DHCP server in internal network. ... On the Connection Type page, click Broadband, and then click Next. ... On the Network Connection, You must enable and configure the network ...
    (microsoft.public.windows.server.sbs)

Loading