Re: New to Windows CE Development - Have some questions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Paul,

Thank you so much for your time and effort to reply to all my questions.
You said:
For your synchronization question, yes, trying to push SQL CE data into
Sybase or Oracle in only one direction won't be a problem.
I say:
So, when I connect my device back to the Enterprise either via the wireless
or USB I can use some feature of SQL Server CE to push records from the local
SQL Server CE table to a Sybase DB via ODBC? I would not have to write any
code to do this?

"Paul G. Tobey [eMVP]" wrote:

> As you might imagine, 'what's different between WM and CE?' gets asked
> constantly. Remember that Google archives all messages to the group. You
> can search here:
>
> http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8
>
> 3. You might imagine that Pocket PC and SmartPhone are configurations of the
> OS which pull in some features and leave out others. The list of features
> pulled in is defined by MS and is called Windows Mobile 5, say, for Pocket
> PC. Each PPC vendor can customize further, of course, but the same basic
> set of components from the OS menu is in each one.
>
> As with Windows Mobile 5, Windows Mobile 3, means one of SmartPhone 2003 or
> Pocket PC 2003. That is, "Windows Mobile" is a generic way of referring to
> both SP and PPC.
>
> As far as your application, you probably *can* use either C++ and unmanaged
> code or VB.NET or C# and managed code. Most of the probable target devices
> run the same processor type, so your EXE would likely work on most of them.
> Whether unmanaged or managed code is right for you will depend on the
> *specific* list of targets and, as you say, your own expertise.
>
> For your synchronization question, yes, trying to push SQL CE data into
> Sybase or Oracle in only one direction won't be a problem, but merge
> replication with one of those is not implemented at all, as far as I know,
> so you'd have to detect what changed on both ends when you tried to
> synchronize and figure out what to do about it. This is a big job (merge
> replication setup on SQL Server is a big job, too, but small compared to
> supporting an arbitrary list of databases).
>
> When connected, you *could* use RDA to do your database I/O, however,
> because you *are* going to be disconnected at times, you'd have to be
> incredibly careful about what's in the local database, so you don't use
> wrong data!
>
> Paul T.
>
> "Nikos_Pontios" <Nikos_Pontios@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:A153021E-4226-4628-99E9-68CC7104A806@xxxxxxxxxxxxxxxx
> > Hello,
> >
> > I have been a developer for 12 years but I am new to Windows CE
> > development.
> > First, I would like to ask a simple question: What is the difference
> > between
> > Windows CE and Windows Mobile?
> > Based on some reasearch that I have done this is what I found:
> > 1. Windows CE 3.x is the base for Pocket PC 2002 and SmartPhone 2002
> > 2. Windows CE 4.x is the base for Pocket PC 2003 and SmartPhone 2003
> > 3. Windows CE is the operating system and Pocket PC/SmartPhone is a
> > platform
> > based on Windows CE. Is a platform a different flavor of the OS?
> > I get a little bit confused when I see something like this: "However, the
> > Smart Device Programmability features of Visual Studio .NET 2003 allow
> > developers to debug the .NET Compact Framework 1.0 applications on Pocket
> > PC
> > 2002, Pocket PC 2000, Windows Mobile-based devices, and Windows Mobile
> > 2003
> > Second Edition-based devices."
> > What is Windows Mobile and Windows Mobile 2003 Second Edition?
> >
> > I also need some quidence on the following scenario:
> > 1. I have an Intermec 751G device with Windows CE .NET 4.2. The device has
> > a
> > wireless card but it can also connect via USB through the cradle.
> > 2. I need to build an application for the device that can work even when
> > you
> > are
> > not connected to the Enterprise. The application needs to download
> > reference
> > data, capture new data and upload the new data to the Enterprise. If
> > the
> > device
> > is connected to the Enteprise we are doing everything real-time. If the
> > device
> > is not connected to the Enterprise we are storing everything locally
> > until we
> > connect back to the Enterprise. When we do connect back to the
> > Enterprise we
> > then synchronize the data between the device and the Enterprise.
> > 3. The application needs to have the flexibility to work on other devices
> > without any
> > major rework. Based on my research, I need to develop in managed code.
> > right?
> > 4. I need to develop this application as soon as possible so I was
> > thinking
> > to use
> > VB .NET since my prior experience has been with fourth generation
> > languages. I
> > have worked with Sybase PowerBuilder.
> > 5. I currently have Microsoft Visual Studio .NET 2003 Enterprise Architect
> > and I
> > can not spend any more money for software. I also have a license for
> > SQL
> > Server 2000 Enterprise Edition.
> >
> > I was thinking to use the following when the device is:
> > 1. Disconnected from the Enterprise: Use SQL Server CE on the handheld to
> > store
> > transactions locally. Once you are connected back to the Enterprise
> > either via
> > wireless or USB(cradle) use Merge Replication between SQL Server CE and
> > SQL
> > Server 2000 Enterprise Edition. If I wanted to work with another DB
> > Engine
> > (Sybase or Oracle) do I have to write an application that will read
> > from
> > the SQL
> > Server CE and synchronize with Sybase or Oracle?
> > 2. Connected to the Enterprise via Wireless: Use ADO.NET or RDA to capture
> > the
> > transactions real-time in the Enterprise.
> >
> > I know it's a lot of questions but please try to help a beginner that is
> > very eager to learn. I have done a lot of research but there is so much
> > information out there that becomes hard to put everything together and
> > make
> > some sense out of it.
> >
> > Thanks in Advance
>
>
>
.

Relevant Pages

  • Re: New to Windows CE Development - Have some questions
    ... pulled in is defined by MS and is called Windows Mobile 5, say, for Pocket ... For your synchronization question, yes, trying to push SQL CE data into ... capture new data and upload the new data to the Enterprise. ... Use SQL Server CE on the handheld to ...
    (microsoft.public.windowsce.app.development)
  • Re: New to Windows CE Development - Have some questions
    ... >2002, Pocket PC 2000, Windows Mobile-based devices, and Windows Mobile 2003 ... capture new data and upload the new data to the Enterprise. ... I also have a license for SQL ... Use SQL Server CE on the handheld to ...
    (microsoft.public.windowsce.app.development)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • Re: Future of Activesync and Pocket Access
    ... solution using the Access database and migrate it later to SQL. ... > activesync quit supporting Access since I have some clients who want a pda ... >> If Microsoft released the next version of Windows Mobile tonight, ...
    (microsoft.public.pocketpc.developer)
  • VB6 SP6 problem with SQL 2000 Enterprise Manager
    ... Since installing SP6 I have had periodic problems with SQL 2000 Enterprise ... Manager. ... Needless to say I also have my database diagrams disappear. ...
    (microsoft.public.vb.bugs)