Solved

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

Posted on 2006-07-14
6
973 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
ID: 17119210
Anyone know how to do this??
0
 
LVL 2

Expert Comment

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

Author Comment

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

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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 2

Accepted Solution

by:
codoherty earned 200 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.

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
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..

0
 
LVL 2

Expert Comment

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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# code editing and collaboration 3 99
Windows and other UI names - The Proper names for the Various elements! 1 61
simplest php form 3 63
batch file problem 5 22
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
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 …

895 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

15 Experts available now in Live!

Get 1:1 Help Now