Differences between OS 4.0 and Windows Mobile 5.0?

[Earl]

I have a complete replication solution built in Compact Framework with
Visual Studio 2003. As prerequisites for my installation, I install the
following cabs:

netcf.all.wce4.armV4.cab
sql.wce4.armv4.cab
sqlce.wce4.armv4.cab

The program, the database interaction, replication, works well on all
PocketPCs up to and including the Dell Axim X5 -- an OS of Microsoft PPC
V4.20.

A client recently bought a new PocketPC, a Dell Axim X51. This uses Windows
Mobile 5.0. Now when I install the prerequisites, I get the message about
those items "not displaying properly". Some posts seem to indicate this
might be a non-issue. However, when I install my program, the program will
run and display properly, but fails with SQL/SQLCE error messages when
attempting data access.

Ok, so what bits am I missing? Are there different prerequisite cabs for
Mobile 5.0? Do I need to import this sucker into a different SDK and
recompile?

 

[Peter Foot [MVP]]

Firstly, .NETCF v1.0 SP3 is in ROM on all WM5.0 devices so don't attempt to
install SP3 or older on these devices. With regards SQL and SQL CE packages
you should use the versions installed with Visual Studio 2005 - here by
default:-
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server
Pick the appropriate version for your project e.g.
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL
Server\Client\v1.0\wce500\armv4i
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL
Server\Mobile\v2.0\wce500\armv4i

Peter

 

[Earl]

Thanks Peter. Recently saw your new library of tools over at
www.devbuzz.com -- very nice work!

 

[Earl]

Am I to take from your post that no changes to the VS2003 CF code will be
required to implement the change from SQLCE to SQLMobile?

 

[Peter Foot [MVP]]

SQL Mobile is a superset of the SQLCE functionality. So yes code you had in
a V1 project will compile against V2 / SQL Mobile with no changes. There are
some new features such as the SqlResultSet you should take a look at, but
generally you can quickly migrate existing code.
For .NETCF the version of the framework and SQL are tied directly together
so for example
..NETCF v1.0 - SQL CE 2.0
..NETCF v2.0 - SQL Mobile (3.0)

Peter

 

[Earl]

Thanks Peter. You got me in the ballpark on the SQL stuff, but the upgrade
from 2003 CF to 2005 CF has not gone well (see my post above). I'm not sure
what is going on, but a simple upgrade has gone psycho. From reading a few
other posts, it's apparently not as simple an upgrade as Microsoft had
intended.