installing sql server mobile in an hp ipaq rx1955

does anybody know how to install sql server mobile and the query analyzer in an hp ipaq rx1955? don't see the samsung processor in the processors list.

thanksWhat is the processor type?
ARMv4/ARMv4i/SH4/MIPS-II/MIPS-IV/MIPS-II FP/ MIPS-IV FP

What is the Windows CE/Mobile OS Version?
3.x, 4.x, 5.x ('About' button would tell you everything)

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation|||The iPAQ 1955 has the following processor: SC32442.

Which processor type should I use from the list?

Thanks|||This device runs Windows Mobile 5 and is ARM compatible.

The CABs you need are:

Location:
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i

Files:
sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
sqlce30.ppc.wce5.armv4i.CAB

-Darren

Installing Sql server 2005 Compact edition

I have a PDA application that manage a database.

My application uses Sql server 2005 Mobile edition and I want to change to

Sql server 2005 Compact edition.

I have an application that automatically upgrade new version of my software at users (customers sites) It is shipped on a memrory card (SD Card).

I want in my upgrade tool to install Sql server 2005 Compact edition so I do it by running the two cab files :

sqlce30.repl.wce5.armv4i.CAB and sqlce30.wce5.armv4i.CAB

It works ok but I want also to uninstall Sql server 2005 Mobile edition and I do not find out how to do it automatically, First I do not know how to find out if Sql server 2005 Mobile edition is installd and if so how to uninstall it.

I want to do it all automatcally in my upgrade utility because my customers do not know to do it manually by theself.

Second I want to know if I have to use the Sql server 2005 Compact edition Uprade tool to upgrade my clients old databases because the now application works ok without Upgrading the database.

Thanks

Ofer Ebert

If your users are using PocketPC devices, you should use these cab files: sqlce30.ppc.wce5.armv4i.CAB, sqlce30.repl.ppc.wce5.armv4i.CAB, the files you mention are for "generic" Windows Mobile 5.0 devices. Installing these cab files will automatically uninstall SQL Mobile. The file format between SQL 2005 Mobile and and SQL 2005 Compact Edition has not changed, so there is no requirement to run the upgrade tool.

|||

Thanks for the quick answer.

I changed to work with the files you mentiond still after installing both cab files I see that SQL Mobile is still installd on my PDA so it is not automatically uninstalld.

Do ypu have a suggestion

Ofer Ebert

|||

How do you determine that SQL Mobile is still installed.
I think you will find that only one set of the files called sqlce...30.dll (sqlcece30.dll and so on) are installed (in the \windows folder).
If these files are dated 22/12 2006, version 3.0.5300, then only SQL Compact Edition is installed.

|||

When running setup/system/ "Remove Programs" I see Sql Compact twice (Because I install two cab files) and also Sql Mobile

Thanks

Ofer

|||

Yes, but please check this:

I think you will find that only one set of the files called sqlce...30.dll (sqlcece30.dll and so on) are installed (in the \windows folder).
If these files are dated 22/12 2006, version 3.0.5300, then only SQL Compact Edition is installed.

|||

Yes I see only one set of files dated 22/12/2006

Thanks

Ofer Ebert

Installing Sql Mobile via CAB file

Hi guys,

wonder if someone can help? I have written an app the runs on PocketPC 2003 and uses CF 2 and Sql Mobile 2005. I need to be able to install my application and Sql Mobile from within a desktop app. This is what I am doing, but I have a few questions:

Using RAPI I copy over to the device; myApp.CAB and sqlce30.ppc.wce4.armv4.CAB.
Using RAPI I then run wceload on these two CAB files.

This works a treat, both application install properly and work!!

But, in the same directory as the sqlce30.ppc.wce4.armv4.CAB (in C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4) there are two other CAB files:

sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB

My application doesn't use replication so I didn't copy over the second file. But what is the first one, and do I need it installed on the device?

Thanks for your help
Graham

Hi

I installed

sqlce30.dev.ENU.ppc.wce4.armv4.CAB

from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4

and

sql.dev.ENU.ppc.wce4.armv4.CAB

from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce400\armv4

and

Installing Sql Mobile via CAB file

Hi guys,

wonder if someone can help? I have written an app the runs on PocketPC 2003 and uses CF 2 and Sql Mobile 2005. I need to be able to install my application and Sql Mobile from within a desktop app. This is what I am doing, but I have a few questions:

Using RAPI I copy over to the device; myApp.CAB and sqlce30.ppc.wce4.armv4.CAB.
Using RAPI I then run wceload on these two CAB files.

This works a treat, both application install properly and work!!

But, in the same directory as the sqlce30.ppc.wce4.armv4.CAB (in C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4) there are two other CAB files:

sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB

My application doesn't use replication so I didn't copy over the second file. But what is the first one, and do I need it installed on the device?

Thanks for your help
Graham

Hi

I installed

sqlce30.dev.ENU.ppc.wce4.armv4.CAB

from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4

and

sql.dev.ENU.ppc.wce4.armv4.CAB

from C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\wce400\armv4

and

Installing SQL Mobile 2005

It is possible to install the .NET Compact Framework from the desktop with a .msi file.

However, SQL Mobile 2005 seems to require you to know the processor which your mobile device uses - there are only CAB files available to do the install.

Have Microsoft made an MSI file available to make this process easier?

matt.
All Windows Mobile (5 and 6) devices use the same processor architecture - ARM, so the problem is minimal.