Re: SQL Mobile Installation Problem on Device

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

Problem Solved!!

Thanks for assisting us in resolving this matter. You were right, we were
missing a critical COM feature from our image. Once that was added SQL
Mobile installs correctly.

Below are the details of what we found and how it was solved.

SQL CE 3.0 is not available as a feature in PlatformBuilder 5.0 (PB) and
consequently must be installed via .cab files. In our case, installing the
..cab files was not successful but the problem was not obvious. Upon
investigation we found that the Registry did not have the expected entries.

Creating a Debug configuration of the CE image and launching it via PB, we
were able to see the following two errors during the installation of the .cab
files:

ERROR: function @ Ordinal 405910 missing in Module 'ole32.dll'

ERROR: function @ Ordinal 190620 missing in Module 'ole32.dll'

Combining a little deduction with some guesswork we fixed the problem by
including the following PB catalog feature in our image:

Applications and Services Development -> Component Services -> Component
Object Model -> COM -> CoCreateGuid functionality for OLE32

The same feature is available under Minimal COM but we didn't try it.


"Bob McCaffrey" wrote:

> Thank your for your response. This is a good suggestion. I will talk to the
> person responsible for creating our OS image today and see if we can find our
> problem using the debugger in Platform Builder. I will give you an update
> after we give that a try. Thanks again.
>
> "Ilya Tumanov [MS]" wrote:
>
> > I don't believe you need to register anything for managed SQL Mobile
> > support.
> >
> > It is likely your OS image has some SQL Mobile dependencies missing.
> >
> > PB debug output should be helpful if that's the case.
> > --
> > 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).
> >
> > "Bob McCaffrey" <BobMcCaffrey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:1C2AA444-1791-4B48-AE82-C210BA3A4DA0@xxxxxxxxxxxxxxxx
> > > Thank you for responding so quickly to my problem. I suspect that you are
> > > correct and that none of the SQL Mobile dll files are registered on my
> > > WCE5
> > > device. I have tried to register them by using the COM DLL registry
> > > utility
> > > (regsrvce.exe) that you recommended in your article titled "Installing
> > > SQL
> > > CE 2.0 and SQL Mobile on a storage card". As I indicated in my original
> > > message, I receive error c1 (basically invalid Win32 app) when I tried to
> > > register these with the utility. To prove that regsrvce.exe worked on my
> > > device I used it to unregister and register the SQL CE 2.0 files. For
> > > some
> > > reason it does not work with the SQL Mobile files.
> > >
> > > Do you have any other suggestions on how I might register the SQL Mobile
> > > dll
> > > files? Is there a different utility that I need to use? Or is it
> > > possible
> > > that there is something wrong with these files?
> > >
> > > "Joao Paulo Figueira [eMVP]" wrote:
> > >
> > >> To solve the Query Analyzer problem, copy *and* register
> > >> sqlceoledb30.dll.
> > >> Query Analyzer is a native application and thus an OLE DB consumer.
> > >> Oddly,
> > >> the setup cab for SQL Mobile will *not* install ssceoledb30.dll. Also, be
> > >> prepared to receive a warning on WM5 devices when running this DLL for
> > >> the
> > >> first time - it's not signed.
> > >>
> > >> --
> > >> Joao Paulo Figueira
> > >> Embedded MVP
> > >> http://nativemobile.blogspot.com/
> > >>
> > >> "Bob McCaffrey" <Bob McCaffrey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> > >> message
> > >> news:E821D8C2-D82B-425E-8695-1EB85DC28449@xxxxxxxxxxxxxxxx
> > >> >I have been unable to properly install SQL Mobile 2005 on my armv4i
> > >> >windows
> > >> > CE 5 device. Below is a summary of what I have found and done. Any
> > >> > help
> > >> > in
> > >> > resolving my issue will be appreaciated. Thanks in advance for your
> > >> > help.
> > >> >
> > >> > Symptoms:
> > >> >
> > >> > No errors occur during installation of SQL Mobile on the device via cab
> > >> > files (either deployed through VS2005 or manually copied and installed
> > >> > on
> > >> > the
> > >> > device)
> > >> >
> > >> > SQL Mobile 2005 appears to be installed, can see it in the device
> > >> > remove
> > >> > programs list. All 7 SQL Mobile dll files are present in the windows
> > >> > folder.
> > >> > (sqlceca30.dll, sqlcecompact30.dll, sqlceer30en.dll, sqlceme30.dll,
> > >> > sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll - version for all files
> > >> > is
> > >> > 3.0.5206).
> > >> >
> > >> > The following error occurs when attempting to create a new or open an
> > >> > existing database using SQL Mobile query analyzer on the device -
> > >> > "Failed
> > >> > to
> > >> > initialize the provider. Please make sure that SQL Server Mobile
> > >> > Edition
> > >> > is
> > >> > properly installed".
> > >> >
> > >> > Problem is not isolated to SQL Mobile query analyzer, a similar problem
> > >> > occurs when attempting to instantiate SQL objects from within a C#.Net
> > >> > smart
> > >> > device test program - "Can't find PInvoke DLL 'sqlceme30.dll'.
> > >> >
> > >> > Problem is not solved by copying SQL Mobile dll files to program
> > >> > folders.
> > >> >
> > >> > No registry entries exist for any of the 7 SQL Mobile dll files under
> > >> > the
> > >> > HKEY_CLASSES_ROOT.
> > >> >
> > >> > None of the dll files for SQL Mobile can be registered manually via the
> > >> > regsrvce.exe program. The error code c1 is returned - invalid win32
> > >> > application (Note SQL CE 2.0 dll files can be successfully registered
> > >> > via
> > >> > this program).
> > >> >
> > >> > Background:
> > >> >
> > >> > The desktop used for development is running Windows 2000 sp4. The
> > >> > develpment
> > >> > enviroment is Visual Studio 2005 Professional Edition (version
> > >> > 8.0.50727.42
> > >> > (RTM.050727-4200). The version of the Microsoft .NET Framework
> > >> > installed
> > >> > is
> > >> > 2.0.50727. The programming language is C#.NET. The device is a 64 MEG
> > >> > Armv4i
> > >> > device running a custom image of windows CE5. The CE5 image was created
> > >> > by
> > >> > Platform Builder with all QFE's through 2005 applied. .NET Compact
> > >> > Framework
> > >> > version 1.0.4292 and SQL CE version 2.0 are included as part of the
> > >> > image
> > >> > (both are in ROM). .NET Compact Framework version 2.0.5238 and SQL CE
> > >> > Mobile are installed via CAB files in the order defined below:
> > >> >
> > >> > netcfv2.wce5.armv4i.cab
> > >> > sqlce30.wce5.armv4i.cab
> > >> > sqlce30.rep.wce5.armv4i.cab
> > >> > sqlce30.dev.ENU.wce5.armv4i.cab
> > >> > system_SR_ENU.cab
> > >>
> > >>
> > >>
> >
> >
> >
.

Relevant Pages