On which platforms is SQL Server 2005 Compact Edition supported.

Will it be possible to run SQL Server 2005 Compact Edition on the following platforms:

Windows 2000

Windows XP (if yes then on which versions of it)

Vista x86

Vista x64

Are there OLE DB providers for SQL Server 2005 Compact Edition?

I have it running comfortably on 2k, XP and Vista 32

I also have it running comfortably in VB6, VS2003 and VS2005|||

The SqlCe will run on this :

http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en#Requirements

And it's not OleDb Provider, but it's SqlCe Providers. It's use the OleDb in under layers.

OleDbConnection -> SqlCeConnection
OleDbCommand -> SqlCeCommand
....

sql

OLEDB query responsiveness vs. .NET/SQL Server Management Studio

I am using OLEDB in C++ and the ATL templates to access a Compact Edition database and SQL Server Management Studio to test queries on it.

The problem I'm having is that SQL Server Management Studio seems to have much better query responsiveness (time to display of first result) than OLEDB, which sort of invalidates my reason for using Studio. Specifically this is the time to just return from ICommand::Execute.

Does .NET (which I assume Studio is using) have an advantage over OLEDB when it comes to query responsiveness? For example, a query that takes two or three seconds to display in OLEDB shows instantaneously in Studio. I even had one query that took 10 seconds in Studio but a minute in OLEDB. This is especially true for queries that involve sorting or distinct. Are there any settings (such as OLEDB properties) I might be missing that would influence this, or is SQL Server Compact Edition fundamentally slower in OLEDB for C++? I'm using a Forward Only cursor which should be the faster one for queries according to the docs.

So apparently the problem is being caused by the parameterized queries I am using... Why would a parameterized query work but take significantly longer for ICommand->Execute to return? Is there some data conversion going on somewhere? I haven't yet tried calling the OLEDB interfaces directly, but it seems to happen with the ATL template classes at least.

OLE DB on Desktop

hello everybody,

I've installed SQL Compact Edition (with Visual Studio 2005) and i try to compile Northwindoledb for the DeskTop. The goal of this operation is to migrate a Pocket PC application (C++/OLE DB/SQL Mobile) to the desktop. If i can run properly Northwindoledb project i could start to migrate ...

I've the following error :

hr = pICmdText->Execute(NULL, IID_NULL, NULL, NULL, NULL);

GUID_NULL undefined

What can i do ?

Thanks in advance !I've found the following definition :

#define DEFINE_GUIDSTRUCT(g, n) struct __declspec(uuid(g)) n
#define DEFINE_GUIDNAMED(n) n

DEFINE_GUIDSTRUCT("00000000-0000-0000-0000-000000000000", GUID_NULL);
#define GUID_NULL DEFINE_GUIDNAMED(GUID_NULL)
I will see if it works ...