 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server CE / April 2008SQL Server CE on PPC, mdb on Desktop pc; how is it possible to exchange data ?
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 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. > Hello. > I'm facing a problem about the interaction between desktop Pcs and [quoted text clipped - 13 lines] > > Newcomsas 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.  SignatureErik Ejlskov Jensen, Mobile App Dev MCTS Check out my SQL Compact blog at http://erikej.blogspot.com > Hello. > I'm facing a problem about the interaction between desktop Pcs and [quoted text clipped - 13 lines] > > Newcomsas |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.