Re: Manual Installation of Mobile SQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have three seperate instances of mobile SQL running on my mobile device. I
understand what two of them are.

Microsoft SQL Mobile 2005
Microsoft SQL Mobile 2005 [EN]
Microsoft SQL Mobile 2005 Replication

Can you tell what "Microsoft SQL Mobile 2005 [EN] is?


"Ilya Tumanov [MS]" wrote:

Yes, you found correct NETCF CAB for your Windows Mobile 5.0 device (that's
the one with "wm" in the name).

In theory you should be able to create and use data base on a flash card. It
might be incorrect path (flash cards can be mapped to different folder.

Some cards have subtle issues and won't work with remote SQL Mobile provider
(which is not very reliable).

Normally it's a good idea to create DB on desktop and deploy it to device
from VS.

Also try creating db programmatically, that might work fine.



By the way, I wonder why you have to do all this. VS 2005 should deploy
everything automatically as soon as you hit F5 to run your NETCF V2 project.



--
Best regards,



Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

"Larry Bird" <LarryBird@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8FA2F59F-B293-448B-9815-79E06409A07A@xxxxxxxxxxxxxxxx
I know I've created a number of post. But now I'm hooked. Eariler I
stated
that I was trying to create a new database on my mobile device via the
Managment Studio. Well it appears that you cannot create a new database
on a
Compact Flash device. Which what I was trying to do. I was successful
creating a database on the mobile device it self.

What do I have to do special to create a database on a Compact Flash
device.
I have a 1 gig Compact Flash with plenty of room. I'm able to read and
write files between the mobile device and my workstation with no problems.

Thanks



"Ilya Tumanov [MS]" wrote:

There are two possibilities:



1. Whatever you looking with does not show CABs. Try DIR command from
command prompt to make sure that's not the case.

2. Files are indeed not in this folder. That might be because they are in
some other custom folder or you have corrupted installation.



Pleas try to repair SQL Server Mobile from ARP and search for files on
all
disks.



--
Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no
rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

"Larry Bird" <LarryBird@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5E0BA3FF-9B40-4AC6-8B78-A74C118922DB@xxxxxxxxxxxxxxxx
OK I located the sup-directory that you mentioned. However, I still
don't
see any CAB files, just DLL's and ZIP files.

I this what I need? Do I just copy them over to the Mobile device?
Once
I
get them on the mobile device how do I get them to install?

Thanks



"Ilya Tumanov [MS]" wrote:

First of all, IntelR PXA270 is an ARM processor, not x86.

Despite common believes, Intel makes quite a few processors which are
not
x86 (e.g. Itanium, MCS x51 families with dozens of different CPUs,
XScale
family and more).

That means x86 CABs won't do. Next, as you correctly pointed out, it's
running Windows Mobile 5 for Pocket PC, not generic Windows CE 5.0.

That means you need CABs with "phone" in the name ("phone" really
means
it's
compressed and signed - format first introduced on SmartPhone).



Thus CAB files you need are located in

"%ProgramFiles%\Microsoft Visual Studio 8\SmartDevices\SDK\SQL
Server\Mobile\v3.0\wce500\armv4i\"



Here's the list:





sqlce30.dev.ENU.phone.wce5.armv4i.CAB
sqlce30.phone.wce5.armv4i.CAB
sqlce30.repl.phone.wce5.armv4i.CAB

--
Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no
rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

"Larry Bird" <LarryBird@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BE9C3FB4-9846-4180-B4A0-558CE33DC76A@xxxxxxxxxxxxxxxx
I'm trying to manually install SQL mobile to my Dell Axim X51v
running
Windows Mobile version 5.0 OS 5.1.1702(Build 14366.0.1)

My processor is an IntelR PXA270
Memory 49.0MB
With a 1 gig CF installed.

I've followed the documentation and tried to locate the CAB files.
I
have
not had any luck in locating the CAB files. I have located ZIP file
and
DLL's.

I do have Visual Studio 2005 and SQL Server 2005 install on my
workstation.
I've located the file "NETCFv2.wce5.x86" in the following
sub-directory:
C:\Program Files\Microsoft Visual Studio
8\SmartDevices\SDK\CompactFramework\2.0\v2.0\WindowsCE\wce500\x86.
Strangely
the file type is listed as a ZIP file. Is this one of the files I'm
looking
for?

I've also located the following files:

sqlce30.dev.ENU.wce5.x86 - file type is ZIP
sqlce30.repl.wce5.x86 - file type is ZIP
sqlce30.wce5.x86 - file type is ZIP

Other files that I've located are:
sqlceca30.dll
sqlcecompact30.dll
sqlceer30en.dll
sqlceme30.dll
sqlceoledb30.dll
sqlceqp30.dll
sqlcese30.dll
upgrade

The above files are in the sub-directory C:\Program Files\Microsoft
Visual
Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\x86

What am I doing wrong here?

What have I missed during the installation on my workstation?

What else must I install to get things working?


Thanks












.

Relevant Pages

  • Re: Manual Installation of Mobile SQL
    ... that I was trying to create a new database on my mobile device via the ... creating a database on the mobile device it self. ... the file type is listed as a ZIP file. ...
    (microsoft.public.sqlserver.ce)
  • Re: Manual Installation of Mobile SQL
    ... to the MSDN SQL Mobile forum - I just spent time answering your duplicate ... in the MSDN SQL Mobile forum. ... creating a database on the mobile device it self. ... the file type is listed as a ZIP file. ...
    (microsoft.public.sqlserver.ce)
  • Re: Purchasing Godaddy cert and mobile phones
    ... To deploy Mobile Device with Small Business Server 2003, ... Microsoft CSS Online Newsgroup Support ... | Will I just be able to rerun the CEICW wizard and import the cert or will ...
    (microsoft.public.windows.server.sbs)
  • Re: how to stop it trying to sync withoutlook email
    ... Has Microsoft issued a fix of this bug? ... The main reason for me getting a mobile PDA was not to have it plugged into ... AS has thrown up a microsoft outlook error message that it couldn't begin to ... disable it from autorunning on my Mobile device so it only fires up when i ...
    (microsoft.public.pocketpc.activesync)
  • Re: Office Campatibility
    ... Windows Mobile devices and Office 2007. ... supported in Office Mobile on Windows Mobile device. ... The new XML-based formats in Office 2007 are essentially a complete ...
    (microsoft.public.pocketpc)