Re: OLE DB Provider not found for SQL Compact edition even after installing


"Dennis Poon" <send2dennishk@xxxxxxxxxxxxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:47bff298@xxxxxxxxxxxxxxxxxxxxxxxxx
But if I use the CoreLab's SDAC, it worked.

When I use exising ADO component and pass the same ConnectionString,
it raises exception saying that particular OLE DB Provider is not found.

Anyone has the same problem?

Been there had the same problem. In my case it was resolved through manual
append of "OLE DB Provider" key under
[HKEY_CLASSES_ROOT\CLSID\{F49C559D-E9E5-467C-8C18-3326AAE4EBCC} (which is
MSSQL CE registry entry) with value "Microsoft SQL Server Compact OLE DB
Provider". Below is result of export for this key:



Windows Registry Editor Version 5.00



[HKEY_CLASSES_ROOT\CLSID\{F49C559D-E9E5-467C-8C18-3326AAE4EBCC}\OLE DB
Provider]

@="Microsoft SQL Server Compact OLE DB Provider"




Actually, is SQL Compact is good database?
Does it support mutli-threading just like SQL Server?
Is it 99% compactible with SQL Server in terms of Data and SQL Query,
Stored Procedures etc?
I chose it just because I though, I could upgrade it to SQL Server in
future painless. Is that true?
From my limited experience CE provider behaves very much different from full
SQL server provider. Most metadata functions don't work. Resulting datasets
are read-only even for simple selects like "select * from [table]". Thus
unless you are planning to make some ad-hock synchronization with mobile
device or any other special considerations of that sort, it would be better
to start development with MS SQL Server Express.


.

Relevant Pages

  • 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: simple question re DELETEing in linked DB
    ... Could not execute query against OLE DB provider 'SQLOLEDB'. ... >>If the remote table is a SQL Server table linked through the OLEDB ...
    (microsoft.public.sqlserver.programming)
  • Re: Oracle Linked Servers
    ... To use distributed transactions with the Oracle OLE DB Provider in your ... I created a blank database in sql server ...
    (microsoft.public.sqlserver.server)
  • Re: OLE DB Provider not found for SQL Compact edition even after installing
    ... it raises exception saying that particular OLE DB Provider is not found. ... MSSQL CE registry entry) with value "Microsoft SQL Server Compact OLE DB ...
    (borland.public.delphi.database.ado)
  • Re: data provider
    ... Do you mean SQL Server Express Edition or SQL Server Compact Edition? ... I am not very experienced with SQL Server, if I choose the later method of using the foxpro OLEDB route does the end user have to have Sql Express install on their pc. ... There are two ways to procede to get VFP data into SQL Server Compact Edition. ... One is to write a .NET app that uses the SqlServerCe namespace for the sdf file and Foxpro OleDb provider for the fox data. ...
    (microsoft.public.sqlserver.ce)