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

Dennis Poon

unread,

Feb 23, 2008, 5:16:59 AM2/23/08

to

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

Dmitry Arefiev

unread,

Feb 24, 2008, 4:29:37 AM2/24/08

to

Hello Dennis

> Actually, is SQL Compact is good database?

That depends on your requirements.

> Does it support mutli-threading just like SQL Server?

Yes, it supports multiple concurrent sessions.

> Is it 99% compactible with SQL Server in terms of Data and SQL Query,
> Stored Procedures etc?

See "Differences Between SQL Server Compact and SQL Server " topic in
"SQL Server Compact Books Online":
ms-help://MS.SSC.v35/MS.SSC.v35.EN/sscmain/html/32840b98-9563-47ec-aca9-038e626e4073.htm

> I chose it just because I though, I could upgrade it to SQL Server in
> future painless. Is that true?

Rather yes, than no <g>

--
With best regards,
Dmitry Arefiev
AnyDAC Team

RemObjects Software
The Infrastructure Company
http://www.remobjects.com

Vitali Kalinin

unread,

Feb 25, 2008, 3:29:28 AM2/25/08

to

"Dennis Poon" <send2d...@yahoo.com.hk.no.spam> сообщил/сообщила в
новостях следующее: news:47bf...@newsgroups.borland.com...

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

Dennis Poon

unread,

Feb 25, 2008, 11:23:44 AM2/25/08

to

thanks so much for your reply.

Dennis
"Vitali Kalinin" <vitka...@yahoo.com> wrote in message
news:47c27c67$1...@newsgroups.borland.com...
>
> "Dennis Poon" <send2d...@yahoo.com.hk.no.spam> сообщи?сообщила ?
> новостях следующе? news:47bf...@newsgroups.borland.com...