Re: Sql SP1: Failed to initialize the provider

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.
.