Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Import an existing SQLCe DB file (.sdf) to eVB emulator

Posted on 2006-07-14
Medium Priority
Last Modified: 2008-01-09
Hi all..

I have an application + a DB of .sdf format. I'm wondering how do i import it into my platform to do test on it through that DB?

my app code is in eVB, i'm using emBedded VB 3.0 to code it. How do i import an existing SQLCE sdf file into  my pc and let my ap the DB ?
Question by:Sylpheed777
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3

Author Comment

ID: 17119210
Anyone know how to do this??

Expert Comment

ID: 17121160
This is a problem!

you can't just copy the sdf to your pc and use it. The database must be synchronised with you PC, the reason is because API's for reading\writing sdf (or pocket access) only exist on the PDA, therefore some synch process is required. Microsoft provides SQL server replication for this task, but this requires IIS and Activesync even though you might just plan to use cable transfer. There are other enterprise products that can do this, one such product I have used that's very easy to use is OneBridge from ExtendedSystems (purchased last year by Sybase).

The other possibilities available to you is to export the data to some other medium, either CSV or there are other open source embedded databases availble.

Another possibility is (but I have not tried this, so I'm unsure). Use SQLMobile I believe these files can be copied to and fro different MS platforms without the need for Synching. But you might not be allowed to have SQLCE and SQLMobile co-exist.

Final possibilities I can think of is to write a transfer process,
1. Create a PC program to use RAPI, the Activesync database sync API to copy records to\fro PC and PDA.
2. Create an IIS process to sync the records (ie. NET remoting or webservice)

Finally! scream....

Author Comment

ID: 17127710
Hmm guess it is a big problem then... I'm tryign well with this, i'm trying to deploy my program directly into my palm, problem is i can't use the Deploy Debug method like i can in

i have to compile it to cab file then run it in the palm, which i find it very very hard to debug :(

I'm getting this error when i try to connect directly to my palm

"The platform Manager could not connect to the device. This happens if the project type does not match the connected device, or if a required file in Windows CE Services, or platform SDK is missing or corrupt. (ErrorCode=0xLX)


"Connection Failed (Error Code = 0xLX) Make sure your device is connected. You may need to verify your configuration by pressing the Configure button in Project Properties. You also may need to reinstall the Platform SDK."

i searched google and found that i can try to test my connection through Project -> Properties -> Configure Target -> Properties -> Transport : PPP transport -> Test

Problem when i click this is "ACtivesync reported the following error: Unable to Load device side components. Please check server configuration."

My startup server config is Microsoft ACtiveSync and when i click config it says "This server does not require any configuration"

Anyone know how to fix it?
The top UI technologies you need to be aware of

An important part of the job as a front-end developer is to stay up to date and in contact with new tools, trends and workflows. That’s why you cannot miss this upcoming webinar to explore the latest trends in UI technologies!


Accepted Solution

codoherty earned 800 total points
ID: 17128969
Ya! I know this error.

You cannot debug your PDA with just any embedded platfform SDK version, your PDA OS version must match the platform SDK version. There is an SDK for each platform version.

Microsoft had an bug in an SDK for an older platform ( WindowsCE 2000 or 2002, can't remember which), this could be solved by changing a regustry entry to match the correct platform GUID. Unfortunately I don't remember which registry entry to fix, so Google it.

In such cases where I cannot debug my application, I use a remote debugging tool found here, but is only for C applications, but if you are serious about your application you will be using C in any case. 

Also, please don't refer to Windows CE devices as palm, as confusion will occur between the Palm Pilot devices. Its generally accepted to refer to Palm Pilot as Palm and Windows CE devices as PDA, Windows Mobile, or WinCE.

Author Comment

ID: 17135273
ic ic ... thx for the advice. really helped :)

ah didn't know Windows Ce <> Palm.. i've always thoguth them to be the same..


Expert Comment

ID: 17137184
Your very welcome, and that why we're all here! for advice :-)

All handheld devices are categorised by OS, because applications are compiled for a specific OS. There 3\4 major OS's available for handheld devices, Palm being the most widely available, with Windows Mobile (previously CE) rapidly gaining market share. This is why is advisable to categorise your device by OS, so immediately other recognise what OS the device is using.

Featured Post

Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Six Sigma Control Plans

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question