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.

OLEDB 7399

Hi everyone,
i have a great problem!
Unexpectedly, my Sql 2000 Server (enterprise edition) is
unable to query data from other sql 7 or 200o servers.
this is very strange, because it has never been appened
until last friday.
It's possible to create link to ather linked servers, but
when I try to do any select query, the erroe is 7399.
The knowledge base articles I have read unitl nuw have
been unuseless.
Please help me with any suggestion.
Thank's
GabrieleMake sure you are connecting to a SQL Server and not an Access database. Th
e error you are getting is for an OLEDB Connection to Access DB.|||I'm sure I'm using SQL.
This is the entire error I receive:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give
any information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface
returned 0x80004005: The provider did not give any information about
the error.].
Regards
Gabriele
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||
>--Original Message--
>Make sure you are connecting to a SQL Server and not an
Access database. The error you are getting is for an
OLEDB Connection to Access DB.
>.
>
I'm sure I'm using SQL.
This is the entire error I receive:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider
did not give
any information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
IUnknown::QueryInterface
returned 0x80004005: The provider did not give any
information about
the error.].
Regards
Gabriele

OLE DB2 Provider

Hi

Running SQL 2005 standard edition, using OLE DB2 provider from Host integration server. When connected we can acces data with select statements, but cannot browse tables from import wizard in SSIS.

Is there a hint or solution?

rgds

It's probably the provider. The Enterprise Edition of Sql Server comes with a DB2 provider. You could also use an ODBC connection instead and see if that works. Finally, IBM might have a provider as well?|||Do you get an error message? I'm using the MS OLE DB2 provider quite regularly and have no issues... Setup is key, though, to getting it to work correctly.

OLE DB Provider for ODBC/Win XP

I have SQL Server Developer Edition which runs on Windows XP and it has been
running fine thus far. I am now trying to run Analysis Services on it and it
needs OLE DB Provider for ODBC. I downloaded MDAC 2.8 and installed it on my
Windows XP platform. The installation went without a hitch but when I go to
Data Sources (ODBC), I cannot see OLE DB Provider for ODBC listed. Does OLE
DB Provider for ODBC only run on Windows 2000 or Windows NT?
Thanks,
AlistairOops, that should be OLE DB Provider for OLAP.
Alistair
"lestersal" <lestersal@.cox.net> wrote in message
news:yLs3c.40660$1k.22567@.okepread01...
> I have SQL Server Developer Edition which runs on Windows XP and it has
been
> running fine thus far. I am now trying to run Analysis Services on it and
it
> needs OLE DB Provider for ODBC. I downloaded MDAC 2.8 and installed it on
my
> Windows XP platform. The installation went without a hitch but when I go
to
> Data Sources (ODBC), I cannot see OLE DB Provider for ODBC listed. Does
OLE
> DB Provider for ODBC only run on Windows 2000 or Windows NT?
> Thanks,
> Alistair
>|||The Data Sources (ODBC) control panel applet only deals with ODBC data
sources and drivers. You are referring to an OLE DB provider.
OLE DB has a similar data sources interface. Try creating a empty text
file, and save it with a .udl file extension. Then double-click that file
and you should get the OLE DB interface.
Brannon Jones
Developer - MDAC
This posting is provided "as is" with no warranties and confers no rights.
"lestersal" <lestersal@.cox.net> wrote in message
news:5oA3c.40902$1k.38183@.okepread01...
> Oops, that should be OLE DB Provider for OLAP.
> Alistair
> "lestersal" <lestersal@.cox.net> wrote in message
> news:yLs3c.40660$1k.22567@.okepread01...
> been
and
> it
on
> my
> to
> OLE
>

OLE DB provider "MSDAORA" for linked server "DBNAME" returned message "

Hi All,

I have a strange problem with one of my Linked server connections. I am connecting from

SQL Server 2005 Standard Edition (9.00.3042.00) to and Oracle 10g database using the Microsoft OLE DB Provider for Oracle. The connection works and I am able to select from all the Oracle tables except for 1 table. When selecting from this table I get the following error:

OLE DB provider "MSDAORA" for linked server "DBNAME" returned message "ORA-01476: divisor is equal to zero".

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider "MSDAORA" for linked server "DBNAME".

This probem happens if the table has rows or has no rows (empty table).

I have tried SELECT * and count(*) along with selecting a specific column from the table.

I can use SQL*plus from the system that the SQL database server running on it and select from the table using the same login/password that the linked server uses to rule out a permissions problem.

Any suggestions on what I can try next?

Thanks.

Did you try using Oracle's own oledb provider? MSDAORA is a legacy provider and not officially supported for Oracle 10g.|||

Yes I had tried that. Found the solution that worked for me:

Provider: used the Oracle Provider

Product name: Oracle

Data source: The database name in TNSNames.ora

And here is the important part. Under the Provider Options for the Oracle provider enable (check) the "Allow inprocess" provider option.

Regards,

Scott

OLE DB provider "MSDAORA" for linked server "DBNAME" returned message "

Hi All,

I have a strange problem with one of my Linked server connections. I am connecting from

SQL Server 2005 Standard Edition (9.00.3042.00) to and Oracle 10g database using the Microsoft OLE DB Provider for Oracle. The connection works and I am able to select from all the Oracle tables except for 1 table. When selecting from this table I get the following error:

OLE DB provider "MSDAORA" for linked server "DBNAME" returned message "ORA-01476: divisor is equal to zero".

Msg 7330, Level 16, State 2, Line 1

Cannot fetch a row from OLE DB provider "MSDAORA" for linked server "DBNAME".

This probem happens if the table has rows or has no rows (empty table).

I have tried SELECT * and count(*) along with selecting a specific column from the table.

I can use SQL*plus from the system that the SQL database server running on it and select from the table using the same login/password that the linked server uses to rule out a permissions problem.

Any suggestions on what I can try next?

Thanks.

Did you try using Oracle's own oledb provider? MSDAORA is a legacy provider and not officially supported for Oracle 10g.|||

Yes I had tried that. Found the solution that worked for me:

Provider: used the Oracle Provider

Product name: Oracle

Data source: The database name in TNSNames.ora

And here is the important part. Under the Provider Options for the Oracle provider enable (check) the "Allow inprocess" provider option.

Regards,

Scott

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

OLE DB Connectivity

Do users need to be setup with the Client Connectivity
only for an application that uses OLE DB to access MS SQL
Standard Edition?
Thanks,
AnjelinaNo, Users you need to have the MDAC installed.
If you send your queries DSN-less in your Apps, they even don´t have
maintain a connection info and their computers (like DSNs)
HTH, Jens Süßmeyer.
"anjelina" <ajturner@.canada.com> schrieb im Newsbeitrag
news:023d01c37b5c$0de07f50$a001280a@.phx.gbl...
> Do users need to be setup with the Client Connectivity
> only for an application that uses OLE DB to access MS SQL
> Standard Edition?
> Thanks,
> Anjelina|||Sorry, my english sounded like this from a drunk, so
the corrected version (just for my ego :)
--
No, you only have the MDAC to be installed on the clients.
If you send your queries in your Apps DSN-less, you
even don´t have to maintain a connection info on the
clients (like DSNs)
--
"anjelina" <ajtuener@.canada.com> schrieb im Newsbeitrag
news:068701c37b67$61096740$a101280a@.phx.gbl...
Thanks a million!!!
Anjelina
>--Original Message--
>No, Users you need to have the MDAC installed.
>If you send your queries DSN-less in your Apps, they
even don´t have
>maintain a connection info and their computers (like
DSNs)
>HTH, Jens Süßmeyer.
>"anjelina" <ajturner@.canada.com> schrieb im Newsbeitrag
>news:023d01c37b5c$0de07f50$a001280a@.phx.gbl...
>> Do users need to be setup with the Client Connectivity
>> only for an application that uses OLE DB to access MS
SQL
>> Standard Edition?
>> Thanks,
>> Anjelina
>
>.
>