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

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?


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?

Thanks a lot.

Dennis


.

Relevant Pages

  • Re: My queries dont work after I upgraded to SQL Server Compact 3.5
    ... It's strange. ... string cSQL = "Insert into Positions ... I have seen something similar with SQL Server so I don't believe it's specific to SQL Compact 3.5 or Compact Framework. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: SQLServer2005/SQLC 3.5 Merge Replication
    ... Check out my SQL Compact blog at ... Create a SQL Server Compact Subscription (SQL Server Management ...
    (microsoft.public.sqlserver.ce)
  • Re: SQLServer2005/SQLC 3.5 Merge Replication
    ... Paul T. ... How to: Create a Subscription (Programmatically) ... Create a SQL Server Compact Subscription (SQL Server Management ... would work with SQL Server 2005 and SQL Compact 3.5? ...
    (microsoft.public.sqlserver.ce)
  • Re: Database for a Pocket PC - Desktop syncing application
    ... New data type - rowversion ... Device Application Development MVP ... I cannot use SQL Compact 3.5 as all my development systems are still using VS 2005. ... I can use SQL Server mobile on PDA but the SQL Server on the desktop will be overkill for my targer audience. ...
    (microsoft.public.pocketpc.developer)
  • SQLServer2005/SQLC 3.5 Merge Replication
    ... Can anyone point me to a smart device sample for merge replication that ... would work with SQL Server 2005 and SQL Compact 3.5? ... a suitably-prepared server database, publication, etc., but don't see how to ...
    (microsoft.public.sqlserver.ce)