access to SQL Server 2.0 CE from .NET Framework
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date: Mon, 22 Mar 2004 04:31:08 -0800
Hello,
I am trying to accede to a BD SQL Server 2.0 CE of a PDA from a .NET (C#) application that is executed on a PC, on .NET Framework not with .NET Compact Framework, without any success.
The procedure wants to bring the .sdf file of the PDA to the PC and also wants to have an application on the PC on .NET able to read what it is wrote on the bb.dd of the PDA.
My problem is that System.Data.SqlServerCe is valid only if it is executed on .NET Compact Framework, I’m trying to do that with OleDB but I don’t have any success.
Have someone been able to accede the bb.dd of a PDA device from an application executed on a PC while the PDA is connected to the PC with ActiveSync?
Many thanks in advance
/Anna
Relevant Pages
- Re: Can Access open to SQL Compact Edition
... I also got some code that worked similiar to this, and I was able to open to a SDF file provided it was local on my desktop/laptop. ... Then I was gonna guery some records from that same table (on the PDA), move that data to the existing records in the Access database, then remove those records manually from the PDA. ... 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. ... I haven't tried using it to open a connection to a SQLce database on a mobile device. ...
(microsoft.public.sqlserver.ce) - Re: Access Database Synchronizer (ADS)
... and it can even delete the sdf file on the desktop when it's finished. ... It was also suggested that I use ADS ... hook-up the PDA to the cradle. ... The laptop holds my Access database and the PDA has my SDF (SQL Compact ...
(microsoft.public.sqlserver.ce) - Re: Access Database Synchronizer (ADS)
... The same app that uses Rapi to copy the sdf file to the desktop can do the updates, and it can even delete the sdf file on the desktop when it's finished. ... It was also suggested that I use ADS ... but I think everyone should know that you can't use ADS if the Access database is going to be on a Vista machine unless you're using WM 6.0. ... I can see and test that the HTTP listner IS running correctly when I hook-up the PDA to the cradle. ...
(microsoft.public.sqlserver.ce) - Re: Access Database Synchronizer (ADS)
... It was also suggested that I use ADS ... And it stops accordingly when I disconnect the PDA. ... I've found the easiest way to do it is to copy the sdf file from the ... The laptop holds my Access database and the PDA has my SDF (SQL Compact ...
(microsoft.public.sqlserver.ce) - Re: Access Database Synchronizer (ADS)
... I've found the easiest way to do it is to copy the sdf file from the device to the desktop using Rapi, then once you're on a desktop it's pretty easy to write a desktop app that can read/write to both the sdf file and any other database you like. ... Access Database Synchronizer to Synchronize between. ... ADS is installed and I have the ADS Wizard on my PDA. ... I presume I have to have the ADS Wizard talking to both databases first? ...
(microsoft.public.sqlserver.ce) |
|
