Go Premium for a chance to win a PS4. Enter to Win


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
  • 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 Vb.net

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?
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

This is about my first experience with programming Arduino.
Make the most of your online learning experience.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Introduction to Processes

927 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