Solved

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

Posted on 2006-07-14
6
968 Views
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 ?
0
Comment
Question by:Sylpheed777
  • 3
  • 3
6 Comments
 
LVL 2

Author Comment

by:Sylpheed777
Comment Utility
Anyone know how to do this??
0
 
LVL 2

Expert Comment

by:codoherty
Comment Utility
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....
0
 
LVL 2

Author Comment

by:Sylpheed777
Comment Utility
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)

and

"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?
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 2

Accepted Solution

by:
codoherty earned 200 total points
Comment Utility
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.

http://www.entrek.com/

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.
0
 
LVL 2

Author Comment

by:Sylpheed777
Comment Utility
ic ic ... thx for the advice. really helped :)

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

0
 
LVL 2

Expert Comment

by:codoherty
Comment Utility
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.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction: Recently, I got a requirement to zip all files individually with batch file script in Windows OS. I don't know much about scripting, but I searched Google and found a lot of examples and websites to complete my task. Finally, I was ab…
This is about my first experience with programming Arduino.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
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…

763 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now