I finally was able to track back some strange behaviour in an
application i've wrote.
In my program i use a sqlCeResultSet for accessing my data. For doing
a refresh (when the underlying data changed), i do a

First off I am using VB.Net 2005 Compact Framework 2.0 with MS SQL
Server 2005 compact.
I am stuck with an SQL Select statement that utilizes 4 columns. I wish
to group 3 of them and sort on the forth using the FIRST function for

Wondering if anyone can point to a cookbook how to install these two database
engines side by side. On a Vista, they installed just fine and both can be
accessed using SQL Server Studio Management Express.
But, on XP Pro only SQL Express is accessible, and is configured by default ...

I have an app which connects to an SQL server via RF.  App is fine, but when
out of range the connection timeout is too long.  I don't want to backlog
data,  in this instance the user must be within range for the connection to
work.

I have a desktop app that I created a deployment package that uses SQL
Xpress. When you start the "Setup.exe" it detects that the application needs
SQL Xpress and downloads it. The first time  I ran the install, the pc I was
using never had SQL Xpress installed so it downloaded ...

Please help me figure out this for those of you that have crossed this
problem.
I've developed an app which now runs on Windows Mobile 2003 and uses CE2 and
SQL Server Agent which was installed over SQL Server 2000 SP3

using the following instractions:
1.
Install SQL Server 2000 SP3a replication components (sql2kxxsp3a.msi)
from the following link.

Does anyone know of a solution to add reporting and charting capabilities to
an embedded application, besides “Roll your own”?   We would like to
seamlessly integrate reports/charts with our current application that
utilizes .NET Compact Framework 2.0 forms based applications for ...

How to overcome the Connection timeout error while executing more than 20000
queries from the File.
I am using Streaming to get the Queries from the File and using SqlCeCommand
to execute Each Query.

Our Windows Mobile 5 application bombs when SQL Server Mobile Edition
3.00.5206.00 throws a message:
ExceptionCode: 0xc0000005
ExceptionAddress: 0x0125aa68

Hello every one,
   While developing I would like to be able to generate a full scrip of my
database in order to save and rebuild each database version, as I did not
found any way to do that using SQL Server Management Studio, and before to

Hi, is it possible to create views in SQL ce?
I have tried using the usual syntax but, it keeps failing.
Is there a different syntax for CE?
Thanks

it's my first attempt to write a database app on my pocket pc... hope
someone can help me...
I created a new project (pocket pc project using VS 2005 Prof) and
within it I added a new mobile database. Then I created a table with

Hi,
1) If I install a SQL CE on a mobile device, how do I perform
synchronization with a SQL server on a desktop?
2) are there any differences to the steps in Q1 if the SQL server on the

I have copied the SDF (SQL Compact Edition) file to the desktop.   I
remember writing code to open to this file, but I can't remember how I did
it.   So, here is what I am doing:
Dim oConn As OleDb.OleDbConnection