SQL CE and PPC 2003

[LawX]

Can anyone tell me if there is any compatibility problem
between SQL CE 2.0 and PPC 2003. I've just tried my app,
that works perfectly well on PPC 2000. I then try to
migrate to another device (running PPC 2003) and after
installing all cab files, including sqlce.ppc3.arm.cab, my
app still bugs as soon as I ask for any SQL query. Please
help me. What am i doing wrong? I saw something strange
while searching for the cause; the windows\sqlce 2.0\ only
contains two .dll files (ssce20 and ssceca20) but no trace
of the Query analyser and others .dll.

I'm going deeper through the rabbit hole as I code
using .NET !

thanks in advance.

 

[Kevin Boske - [MS]]

Does your application encounter exceptions when executing a SQL Query?
What is that exception?

There are two .CAB files. One is the sqlce.dev.ppc3.arm.cab, it contains
the Query Analyzer and System.Sr.dll (error strings).


Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
Content-Class: urn:content-classes:message
From: "LawX" <[email protected]>
Sender: "LawX" <[email protected]>
Subject: SQL CE and PPC 2003
Date: Thu, 28 Aug 2003 08:46:24 -0700
Lines: 16
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcNte4jdeMZohpQRSriqTMWvVtFE4g==
Newsgroups: microsoft.public.dotnet.framework.compactframework
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:32260
NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Can anyone tell me if there is any compatibility problem
between SQL CE 2.0 and PPC 2003. I've just tried my app,
that works perfectly well on PPC 2000. I then try to
migrate to another device (running PPC 2003) and after
installing all cab files, including sqlce.ppc3.arm.cab, my
app still bugs as soon as I ask for any SQL query. Please
help me. What am i doing wrong? I saw something strange
while searching for the cause; the windows\sqlce 2.0\ only
contains two .dll files (ssce20 and ssceca20) but no trace
of the Query analyser and others .dll.

I'm going deeper through the rabbit hole as I code
using .NET !

thanks in advance.

 

[Alex Feinman [MVP]]

Isn't the cab for 2003 devices called sqlce.dev.wce4.arm.cab?

 

[LawX]

Actually, when the exception occurs, the only Message and
hresult code I get or irelevant, The message is '0' and
the hresult doesn't mean anything in my opinion.

I would really be interested if you can give me the name
of the second .cab file that is needed to deploy SQLCE,
sqlce.dev.ppc3.arm.cab is the one I used, but, apparently,
it's not enough!

I also looked for sqlce.dev.wce4.arm.cab, that Alex
advised me, but I can't find it on my computer, I'll look
over the web.

Waiting for more details about this second .cab file.
Thanks for all.

-----Original Message-----
Does your application encounter exceptions when executing a SQL Query?
What is that exception?

There are two .CAB files. One is the

sqlce.dev.ppc3.arm.cab, it contains

 

[Kevin Boske - [MS]]

There are two (four) cabs for SQL Server CE.

The developer Cab includes Query Analyzer, and the error strings. It comes
in two actual files, one for PocketPC and one for Windows CE 4.x devices:

sqlce.dev.ppc3.<processor>.cab
sqlce.dev.wce4.<processor>.cab

and

The SQL Server CE cab, which includes the engine, client agent, managed
extentions for the client agent. It also comes in two actual files, one
for PocketPC and one for Windows CE 4.x devices:

sqlce.ppc3.<processor>.cab
sqlce.wce4.<processor>.cab

All of these cabs should be included in your Visual Studio .NET 2003
Professional Edtion install. The default location is

\program files\Microsoft Visual Studio .NET
2003\CompactFrameworkSDK\v1.0.5000\Windows CE\...


What is the HResult you get? It may be relevent. Most of the HResults come
from either IIS, when using RDA or merge replication or OLEDB when using
SQL Server CE.


Kevin Boske
([email protected])
SQL Server CE Team
Microsoft
----------------------------------------------------------------------------
----------------------------------------
Everything you need to know about SQL Server CE:

http://www.microsoft.com/sql/ce/techinfo/default.asp
----------------------------------------------------------------------------
----------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
----------------------------------------------------------------------------
----------------------------------------
--------------------
Content-Class: urn:content-classes:message
From: "LawX" <[email protected]>
Sender: "LawX" <[email protected]>
References: <[email protected]>
<[email protected]>
Subject: RE: SQL CE and PPC 2003
Date: Fri, 29 Aug 2003 01:12:59 -0700
Lines: 94
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Thread-Index: AcNuBVvs2MAyjtycTwWIoyXbq6K9Gg==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.dotnet.framework.compactframework
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.compactframework:32327
NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

Actually, when the exception occurs, the only Message and
hresult code I get or irelevant, The message is '0' and
the hresult doesn't mean anything in my opinion.

I would really be interested if you can give me the name
of the second .cab file that is needed to deploy SQLCE,
sqlce.dev.ppc3.arm.cab is the one I used, but, apparently,
it's not enough!

I also looked for sqlce.dev.wce4.arm.cab, that Alex
advised me, but I can't find it on my computer, I'll look
over the web.

Waiting for more details about this second .cab file.
Thanks for all.

-----Original Message-----
Does your application encounter exceptions when executing a SQL Query?
What is that exception?

There are two .CAB files. One is the

sqlce.dev.ppc3.arm.cab, it contains