I have tried using the documentation but can not figure this one out
so I am requesting some expert advice:
First I will explain what I want, then show you how I got it using MS
Access and then someone, hopefully, can steer in the right

have an .sdf database (MS SQL 2005 Compact)  that was created on a
pocket pc. It now resides on the desktop. I wanted to open it and edit
it on the desktop. I am developing with Vb.2005.
I use the same connection string syntax that I use on the Pocket PC

I have installed VSTO 2005 and have discovered that the designer tools for
SQL Compact Edition do not function.  They appear to function fine in VS 2005
Professional but not in VSTO.
Does anyone know how to get the tools to work in VSTO or do I have to now

Hi I am using sqlce on my desktop and trying to write a query that
sums two fields. I am an Access guy and built this query there. When I
tried to use it in my application it crashes
Dim sqlStands As New SqlCeCommand("SELECT si_stand, Sum(si_size) AS

I have VB.net application which has SQL Server Compact Edition 2005
Database as backend. In VB.net coding i am using Sqlserverce classes
to connect this database. It works well when I run the application in
local drives. But its not working when I run the application from

I need to provide monitoring mobile devices using Windows mobile 6.0 and MS
SQL Server 2005 ME. It have to be some counters for monitoring the mobile
devices or Management Pack for MOM, or both, or somewhat else.
Please, if who else have solved such task share info.

I am to begin developing CE database applications that are going to
need direct connectivity to a full SQL Sever database or at least
*seem* like they are directly connected.  I am thinking that SQLServer/
CE is the logical way to proceed, but how do I get the data from

Created a SDF in VS2008.  Saved it to VSS and saw that a field was
misspelled.  Welp used Server Explorer in VS2008 to connect to it but could
not modify the schema field names at all.
Then went into SQL 2005 and tried to connect to it and it said if it was CE

We have developed an application with vb2005 running under WM5.0 how
connects direct to SQL Server 2005 using WLAN (Using system.data.sqlclient
ver 3.0.3600 from  ..\Smartdevices\sdk\SQL
Server\Client\v2.0\system.data.sqlclient.dll).

I've been using Visual /studio 2005 and sqlserver  2.0 ce for a few months
now (for deployment to a pocket pc). I've been able to add the sdf database
file to the project and then double click on it to open it and enter/edit the
data in the tables. However just recently I cant do ...

From other posts on the net i understand that there is no JDBC driver for
SQL CE, however is there any way to connect a Java client to SQL CE? any code
is appreciated.
thanks

My app is working on my local system with the vs2008 development server. It's an asp.net app and I added the line:
           AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true);
So it works fine on my system. But I can't get it to work on shared ...

I'm using an Intermec Pocket PC v4.20.1081 with an ARM PXA255
processor.  It is connected to my computer, with is running SQL Server
and Visual Studio 2005.  I am using VB to write database apps on the
Intermec.

Hi all together,
I am migrating an SQL project to SQLCE 3.5
A statement like
(SELECT  <column_list> FROM Table AS a

I have written a quite big retail application for Windows Mobile. It uses
Sql Server Compact Edition. A typical itemregister has up to 40000-50000
items.
I'm very pleased with Sql Server Compact Edition, but has one problem. The