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

You could use RAPI to copy the sdf file from the device, manipulate on the
desktop having both an SQL Compact and Access connection open, and then use
RAPI to copy the sdf file back to the device.

--
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

"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: SQL Server CE on PPC, mdb on Desktop pc; how is it possible to exchange data ?
    ... You could use SQL Compact on both the desktop and the ... use one of the server versions on the desktop and use either RDA or Merge ... is it anyway possible to launch the connection ... tables from Access to SQLCE and a table back from SQLCE to Access. ...
    (microsoft.public.sqlserver.ce)
  • Re: Connection hanging after using(....) construct
    ... closing line as the blocking one. ... IDbConnection connection = NewConnection ... singleton connection object for my SQL Compact apps. ... objects for Compact Edition or MSDE. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL CE Install with Visual Basic Express 2008
    ... In Data Explorer, select Add Connection, in the Add Connection dialog, click the change button near the top, and select SQL Compact. ... If SQL Compact is not in the list displayed, repair your installation or re-install SP1. ...
    (microsoft.public.sqlserver.ce)
  • Re: Connection hanging after using(....) construct
    ... One other thing you might try is making sure each thread has its own connection, although in your testing I don't know if multiple threads were used. ... IDbConnection connection = NewConnection ... singleton connection object for my SQL Compact apps. ... Sometimes the test hangs in the ...
    (microsoft.public.sqlserver.ce)
  • Re: Can Access open to SQL Compact Edition
    ... There is a managed wrapper for the Rapi functions on www.opennetcf.org in the Desktop Communication section. ... The Microsoft Mobile Development Handbook by Wigley, Moth and Foot has some good chapters on SQLce as well as lots of other good stuff and is definitely a book you'll want. ... So, I've tried opening this on the PDA, and I moved the SDF file manually to the desktop to try and edit it there. ... I haven't tried using it to open a connection to a SQLce database on a mobile device. ...
    (microsoft.public.sqlserver.ce)
Loading