Solved

PPC 2003 and vb.net - What is the best database to use?

Posted on 2004-09-13
4
480 Views
Last Modified: 2013-11-18
Greetings,

I have an assignment to create a data collection program on a PPC 2003
handheld.  I will be using visual studio VB.NET to program this application.
The collected data will then be uploaded to a workstation and imported into a
database application written in VB6 which uses ADO and .MDB databases.  The
data structure is fairly complex and includes several tables, keys, forms
and relationships between tables.

I have about 17 years programming experince, so the question I ask is more
one of best practices.  This is my first assignment with programming for a
handheld device.

The question is this.  When I pass historical customer/survey information
and pass it to the handheld, and when the handheld collects information and
later passes it to ther head office server, what format should it best be
collected, stored and transmitted?

Should I use XML or use some type of other database (MDB?)

Note that the relationships between the data elements is not trivial - this
fact may play a role in what is done. Note also the data size will be
substantial.

Cust#
   -  Contact Information (Name, address, etc.)
   -  Plant configuration
                 - System 1 and notes
                             - Test 1 expectations
                             - Test 2 expectations
                 - System 2
                 - System 3
  - Service Calls
                 - Jan 15
                        - System 1 Notes
                               - Test 1 Results
                               - Test 2 Results
                        - System 2 Notes
                               - Test 1 Results
                               - Test 2 Results
                 - Feb 4
                        - System 1 Notes
                               - Test 1 Results
                               - Test 2 Results
                        - System 2 Notes
                               - Test 1 Results
                               - Test 2 Results



Thanks
Stephen

0
Comment
Question by:StephenSimpsonx
  • 2
4 Comments
 
LVL 48

Expert Comment

by:Mikal613
ID: 12047714
a) you can use SQl sever CE  (which is preferred) by most

b) you can use Pocket Access from handango.com for like 40$ which you can use active sync and it will convert the databse to pocket from Regular access and vice versaq

c) use a web service and get up to the second  updates using xml

http://abstractvb.com/code.asp?A=1004
0
 
LVL 1

Accepted Solution

by:
wselles earned 500 total points
ID: 12122090
Stephen,

I'm working on a similar project: Data collection on PPC and storage + extra functionality on Desktop.
I use VB.Net for both. I agree with Mikal, but want to add my experience:

The data I store is very hierarchical (10 levels). Alle levels have collections with an undefined number of members. This makes it very complex to store in SQL or Access.

The next best solution would be to use the xmlSerializer to Serialize my object to xml. For my app., this wasn't suitable, because 1/ It took too long 2/ There's no way of checking whether all stored info was retrieved when unserializing. This because any corrupted info will be skipped by the .NET xmlserializer. Any format changes are risks too btw.
Should you want to know more check these links:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnword2k2/html/odc_UsingDotNetFromVBA.asp
http://www.microsoft.com/downloads/details.aspx?FamilyID=7cc0f8e8-483a-4447-ba5d-92b85fb1dc55&DisplayLang=en
http://www.topxml.com/xmlserializer/default.asp

I myself went back to an older method: a flat file dB, using streamreader/writer. After testing, this proved to be a good solution: it is fast, easy, flexible, creates small data files, etceteras.

It might sound silly, and surely it's not a 'hot' solution, but it works fine.

I hope this helps. Developing for the PPC is different (with low speed as example). Let me know if you want to know more.

Cheers,
ws



0
 
LVL 1

Expert Comment

by:wselles
ID: 12133997
To be clear: I use a flat-file dB to transfer data from PPC to Desktop, where it is stored in an access dB, and part is abstracted and stored on a central dB (no decision yet, SQL Server or simply Access too).
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Preface: This article is part of a series focused on cross platform mobile app development (specifically Android and iOS) using the Alloy framework and Titanium Studio made by Appcelerator (https://www.appcelerator.com/). This article presumes a wor…
In this article we will discuss all things related to StageFright bug, the most vulnerable bug of android devices.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

832 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