Re: Sql SP1: Failed to initialize the provider

Tech-Archive recommends: Speed Up your PC by fixing your registry

I am sorry that I told HKCU. Yes, you are right it is HKCR.

Some how, I don't believe the fact that DLLs are installed multiple places
and there multiple copies of them. Also, I am not sure why the
installations are so hairy in the directory structure. This is what it
should look like:

ROOT: .<Storage Root>\Microsoft SQL Server Compact Edition\v3.5

ROOT should have: sqlcese35.dll, sqlceqp35.dll, sqlceme35.dll,
sqlceca35.dll, sqlceoledb35.dll, sqlcecompact35.dll, sqlceer35en.dll,
isqlw35.exe

In a sense, all DLLs should get copied into same folder and I see it being
not the case in your device.

If I am not wrong, you said things did not work on main memory installation
too. How was the installation directory in that case? I see that there is
an issue with NAND Flash and Setup integration. Can you let me know the
story if you just get rid of flash card for a while (just for testing) and
do your troubleshooting on main memory.

Thanks,
Laxmi

"Cloud Strife" <C_strife@xxxxxxxxxx> wrote in message
news:eFfNk.3297$8%.97@xxxxxxxxxxxxxxxxxxxxxxxx
Laxmi Narsimha Rao Oruganti [MSFT] ha scritto:
Did you try your test program of co-creating SQL CE OLEDB CLSID and it
fails even now?

If it fails even with fresh intall, then can you let us know the contents
of the following registry hives (including subkeys and values):
1) HKLM\Software\Microsoft\Microsoft SQL Server Compact Edition\v3.5
2) HKCU\CLSID\{F49C559D-E9E5-467C-8C18-3326AAE4EBCC}

Thanks,
Laxmi


Hi Laxmi,
you're right: even after a fresh install I cannot co-create SQL CE OLEDB
interface.

Here's what I have in the registry under HKLM\Software\Microsoft\Microsoft
SQL Server Compact Edition\v3.5:

-----
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Compact
Edition]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Compact
Edition\v3.5]
"NativeDir"="\\NAND_Flash\\Microsoft SQL Server Compact Edition\\v3.5"
"InstallDir"="\\NAND_Flash\\Microsoft SQL Server Compact Edition\\v3.5"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Compact
Edition\v3.5\ISQLW]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Compact
Edition\v3.5\ISQLW\Font]
"FontSize"=dword:0000000a
"FontName"="Verdana"
-----


Furthermore: under HKCU (HKEY_CURRENT_USER) I cannot find subkey CLSID; I
find it under HKEY_CLASSES_ROOT, but however subkey
"F49C559D-E9E5-467C-8C18-3326AAE4EBCC" does not exist!!!

Just be clarify my situation, here follows the listing of all files &
folders on my device flash disk (regarding Microsoft SQL Server CE
installation):


-----

Directory of \NAND_Flash\Microsoft SQL Server Compact Edition

08/01/60 01:39a <DIR> v3.5
08/01/60 01:42a <DIR> Tools
08/01/60 01:42a <DIR> Repl
08/01/60 01:44a <DIR> EN
01/01/00 12:13a 0 out.txt
12/21/06 06:33p 26112 dbnetlib.dll

Found 6 file(s). Total size 26112 bytes.

Directory of \NAND_Flash\Microsoft SQL Server Compact Edition\v3.5

10/01/07 11:49p 449328 sqlcese35.dll
10/01/07 11:49p 952624 sqlceqp35.dll
10/01/07 11:48p 63280 sqlceme35.dll

Found 3 file(s). Total size 1465232 bytes.

Directory of \NAND_Flash\Microsoft SQL Server Compact Edition\Tools

08/01/60 01:42a <DIR> v3.5

Found 1 file(s). Total size 0 bytes.

Directory of \NAND_Flash\Microsoft SQL Server Compact
Edition\Tools\v3.5

08/01/60 01:42a <DIR> EN
10/02/07 12:02a 144184 sqlceer35EN.dll
12/21/06 06:33p 26112 dbnetlib.dll

Found 3 file(s). Total size 170296 bytes.

Directory of \NAND_Flash\Microsoft SQL Server Compact
Edition\Tools\v3.5\EN

10/01/07 11:48p 144176 isqlw35.exe
12/21/06 06:33p 26112 dbnetlib.dll
10/02/07 12:02a 144184 sqlceer35EN.dll
10/01/07 11:49p 215344 sqlceoledb35.dll
10/01/07 11:48p 86320 sqlcecompact35.dll
10/01/07 11:49p 479024 sqlceca35.dll
10/01/07 11:49p 449328 sqlcese35.dll
10/01/07 11:49p 952624 sqlceqp35.dll
10/01/07 11:48p 63280 sqlceme35.dll

Found 9 file(s). Total size 2560392 bytes.

Directory of \NAND_Flash\Microsoft SQL Server Compact Edition\Repl

08/01/60 01:42a <DIR> v3.5

Found 1 file(s). Total size 0 bytes.

Directory of \NAND_Flash\Microsoft SQL Server Compact
Edition\Repl\v3.5

10/01/07 11:49p 479024 sqlceca35.dll
10/01/07 11:49p 215344 sqlceoledb35.dll
10/01/07 11:48p 86320 sqlcecompact35.dll

Found 3 file(s). Total size 780688 bytes.

Total Files Listed:
26 File(s) 5002720 bytes.
7 Dir(s) 59803136 bytes free


-----


Thanks again for the collaboration. I look forward for receiving news from
you soon.


.

Relevant Pages

  • Re: SQL Server 2005 Compact Edition - How is it deployed?
    ... Now I got a notice from a colleague of mine, reporting problems with running my app on Windows XP, SP 2, .net 3.5 runtime installed. ... Obviously the setup does not automatically deploy the CE runtime to the target. ... Is the separate installation of "SQL Server Compact 3.5" sufficient? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Which database for WM3 and WM5 development using CS.NET
    ... Yes, they seem to change names as often as they change socks, although this ... You can run it on both of the mobile device ... Visual Studio 2008 installs SQL Server Compact 3.5 for Devices if the Smart ... with my SQL 2005 server installation, ...
    (microsoft.public.sqlserver.ce)
  • How to distribute SQL Server Compact 3.5
    ... I've written my mobile application using VS2008 and SQL Server Compact ... I plan to recompile and target for ... and OTA installation, ...
    (microsoft.public.pocketpc.developer)
  • cant find pinvoke dll sqlceme30.dll
    ... I am having trouble with SQL Server Compact Edition 3.1 on windows CE 5 on a ... Running the same code on another windows ce 5 device works fine. ... installation directory i.e \windows: ... Please make sure that SQL Server Compact ...
    (microsoft.public.sqlserver.ce)
  • Re: Database Landscape for future Delphi work.
    ... I'm 100% sure that SQL Server Compact Edition is in-process. ... Might Interbase or Firebird have this option to run in-process (via dlls)? ... But, out of curiosity, how would this work for a Delphi app? ...
    (borland.public.delphi.non-technical)