SQL Mobile Installation Problem on Device
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 Builderwith all QFE's through 2005 applied..NET CompactFramework version 1.0.4292 and SQL CE version 2.0 are included as part of the image (both are inROM)..NET CompactFramework 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
Just to narrow down the problem, can you please try these if possible:
1) Build the custom image with Platform builder with out SQL CE 2.0 in ROM (Having .NET CF 1.x is upto you)
2) Are you trying to install on a CF/SD/Memory Card? If so, can you please try installing the SQL Mobile 3.0 on main memory?
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
Thank you for your response.
Item 1 - Have already tried this, I get the same result whether SQL CE 2.0 is in my image or not.
Item 2 - I am trying to install SQL Mobile in main memory.
Do you have any other suggestions?
I am having this exact same issue with a Dell X51v running Windows Mobile 5. (
"Can't find PInvoke DLL 'sqlceme30.dll'.)
I am developing in VS2005 and SQL 2005 Mobile. When using a 2003 Second Edition device I can start debugging from the dev environment and everything (CF, SQL) gets installed on the device automatically. It just works.
With the WM 5.0 (Dell) the framework gets installed but not SQL Server. I tried manually installing SQL Server and like above post I get "Failed to initialize the provider.."
Any ideas?
I solved my own problem. VS is sending the cab files for SQL Mobile into the Windows folder on the device but isn't/can't install them. I ran them (5 cab files) from the device and now it works.
Problem Solved!!
Our problem turned out to be the same issue that Mika Laaksonen posted and solved last November.
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.
Glad that you all have solved and things are working. Thanks for using SQL Mobile.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
Hi Lami,
can you give me detailed steps of how to do the following
Regards
venkat.
"Our problem turned out to be the same issue that Mika Laaksonen posted and solved last November.
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."
The content has everything. In platform builder, include the following PB catalog feature with the image:
Applications and Services Development -> Component Services -> Component Object Model -> COM -> CoCreateGuid functionality for OLE32
What more details you want? May be I did not get your question. Can you please elaborate?
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
Hi Laxmi,
I got the problem with Pocket PC 2003 Phone edition not with windows mobile 5. I am using Visual Studio 2005 to do the test deployment on my pocket pc. I have no clue about platform builder. Kindly help me out with this.
Regards
Venkat
1) Are you trying to install SQL Mobile on storage card. Try installing on main memory.
2) Also, can you please install SQL Mobile bits manually on the device/emulator and see if the problem goes off. You can get the SQL Mobile binaries from
%ProgramFiles%\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4
3) Open Query Analyzer and try creating the database, are you able to?
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
I have fixed the
"Can't find PInvoke DLL 'sqlceme30.dll' problem copying the following files to the Windows directory of my Mobile Device and installing them:
sqlce30.dev.ENU.phone.wce5.armv4i.CAB
sqlce30.phone.wce5.armv4i.CAB
sqlce30.repl.phone.wce5.armv4i.CAB
Hi,
I see you suggest installing SQL Mobile 3.0 to main memory instead of to the storage card. Can you tell me why this may cause errors?
Thanks
...and what, if I don′t have "PlatformBuilder"?
What is the "real fix"?
On my WinMob. 5.0 device everything is properly installed:
SQL Mobile 2005, Query Analyzer, Database. Query Analyzer is working, I can execute SQL-Statements against the database. No problem.
sqlceme30.dl and all the other dlls are located in \\Windows-Folder.
But the error is still the same: "Can not find PInvoke-DLL 'sqlceme30.dll'"
And now?
Thanks for your hints.
Mike
I am having the exact same problem on my O2 XDA II mini running Windows Mobile 2003 SE. I tried everything in this thread but still no luck.
I would appreciate your help.
