Fix for not listed Sql CE OleDB provider

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

With the registry settings below ( based on the reg changes the beta
versions did make) you can make the OleDB provider for SqlServer 2005 CE in
the list of OleDB provider in the Ado Select/Change Connection wizard
dialog.
Use it on your own risk!!

Erik


Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}]
@="Microsoft.SQLSERVER.MOBILE.OLEDB.3.0"
"OLEDB_SERVICES"=dword:fffffffe

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\ExtendedErrors]
@="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows
Error Lookup"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\ExtendedErrors\{D9007E8B-A33A-4429-B0FC-7FC211DB8110}]
@="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for
WindowsError Lookup"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\InprocServer32]
@="C:\\Program Files\\Microsoft SQL Server Compact
Edition\\v3.1\\sqlceoledb30.dll"
"ThreadingModel"="Both"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\OLE DB
Provider]
@="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\ProgID]
@="Microsoft.SQLSERVER.MOBILE.OLEDB.3.0"

[HKEY_CLASSES_ROOT\CLSID\{32CE2952-2585-49a6-AEFF-1732076C2945}\VersionIndependentProgID]
@="Microsoft.SQLSERVER.MOBILE.OLEDB"


.

Relevant Pages

  • Re: Adding a data source to a project
    ... I reinstalled the SQL Server 2005 Mobile. ... The provider is installed with the installer, but just does not show up in ... Is this the only way to get the provider for SqlServer 2005 CE installed?? ... @="Microsoft SQL Server 2005 Compact Edition OLE DB Provider for Windows ...
    (microsoft.public.sqlserver.ce)
  • Re: Disabling ASP.net 2.0 Membership
    ... I checked out the article you referenced and implemented my own provider. ... as a FoxPro database, an Oracle database, or other data sources. ... custom connection string so that I can use the Commerce Server SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ERROR: Provider Management - Could not establish a connection to t
    ... If you have not yet created the SQL Server database, ... Can any data provider be used to ... Exception Details: System.Data.SqlClient.SqlException: A connection ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: .NET data provider or OLEDB provider?
    ... >I don't see where you see a built-in query engine. ... >service provider, ... >OLE DB providers don't have to support SQL however, ... > SQL Server linked server, SQL Server can handle the queries. ...
    (microsoft.public.data.oledb)
  • Re: Need Help: Operating system error 3706
    ... Installing an additional component resolved the problem and the software is now able to connect to the database ... The developer is currently doing a complete rewrite/update of the program, including database functions. ... While this would require a modest re-write, it's not that tough to convert to a managed-code provider instead of the COM-based OLE DB provider. ... If the application is not based on .NET, then make sure the application is upgraded to use the SNAC (SQL Server Native Client) provider which is less trouble-prone than the older MDAC-based providers. ...
    (microsoft.public.sqlserver.connect)