Hi Tim,
Welcome to MSDN newsgroup.
As for the SQL CE and Sdf file , it can only be accessed and edit on our
devices, on desktop environment there is no such API for directly editing
Sdf based database... We have to provide SQLserver and IIS server if we
need to make Sdf file's data synchornous with our modification on desktop
since we can only do data accessing to SQLserver through desktop
application interface....
And using XML as intermediate storage is one possible approach is you're
doing some data transfer service like operation. But for runtime data
communication or synchornizing , I don't think it'll suit due to
performance consideration....
also, I suggest you try posting in some Device or programming related
newsgroup to see whether some other community members have some experience
on this...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure!
www.microsoft.com/security (This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| Thread-Topic: sdf and Access
| thread-index: AcYML9ZUeAvvP5HxRBKuX+7vbVnPyg==
| X-WBNR-Posting-Host: 69.255.62.2
| From: "=?Utf-8?B?RWViZWw=?=" <Eebel@nospam.nospam>
| Subject: sdf and Access
| Date: Wed, 28 Dec 2005 20:25:02 -0800
| Lines: 25
| Message-ID: <6C185066-815B-4E07-BDED-5AE9DF82E429@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.clients
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.clients:31198
| X-Tomcat-NG: microsoft.public.sqlserver.clients
|
| Hi,
|
| I want to store data on my Pocket PC in an SDF file and then use
ActiveSync
| (4.0) to have that SDF file synced to the sdesktop. Now, I need some way
to
| read that SDF file on the Desktop and populate and Access database.
|
| My users do not and will not have sql server or any internet information
| services... They are regular users not corporate users.
|
| I am using CFCOM to read my cdb on the device and turn it into and SDF on
| the device. CFCOM only seems to work on VS2003. VS 2003 produces a SQL
CE 2
| database. VS 2003 does not seem to be able to read SDFs. I have VS 2005
but
| it uses sdf with an incompatible format to VS2003.
|
| I am rewriting my main app in VS 2005, but I need a solution now for the
| intermin.
|
| I tried dumping My CDB to XML and it was horribly slow (over three
minutes).
|
| Any ideas?
|
|
| --
| Tim
| TSE Digital Productions
|
