I am getting an occasional disk IO error when power is restored to
handheld.  Using SQL CE 2.0 with .NET CF on Symbol MC9090 handheld
(WM5).  We store all the databases and temp files on a SanDisk 2G SD
card.  When power is restored, we even close the connection and reopen

Has anyone developed applications, using both ado.net and oledb, to access
sql compact?  What has your experience been with regards to performance?  In
our case, using oledb has been consistently slower than ado.net, at least
for SELECTs.  Is the oledb provider a ...

I am serching table entries in a replicated Table (SQL Server 2005
merge replication download only) by scanning the index. everything
works but if I have new entries on the Table it seems that the index
will not been updated and the new entries will not been found. The

As the DataGridBoolColumn is not supported in the CF ( is this correct) I
like to find a way to find a user friendly way to edit a boolean in a grid.
If is now displayed as True / False.
Are there any samples of a Boolean columnstyle?

When I use the Microsoft.SQLSERVER.MOBILE.OLEDB3.0 provider to connect to a
SDF file, , i cannot open table with one or more nVarchar columns designed
wider than 127 chars.
Is this a known / documented limitation?

I have a smart device VB.NET solution. In SQL Server 2000 i have a database 4
masters tables (Products, Customers, Company, Salesman). This tables are
uploaded in the SQL CE using a replication. This tables are read only. Now I
have 2 more tables (Inventory) that are the ...

If I run a query that returns an error, say a SELECT on a non-existent
column, I receive the following error message:
The column name is not valid. [ Node name (if any) = ,Column name = x ]
Is there any way to retrieve the offending column name?

I have an application written in c# that uses the SqlCeDataReader class to
iterate through the result set of a query (all reads, no writes, no backward
scrolling), and an equivalent c++ app that uses oledb to perform the same
task .  The performance of the c++ app is about 3.5 ...

I’m VC++ programmer and I want to use database in Windows mobile, Is there
any way to use MS Access in Win mobile or I must use MS SQL server Mobile?
I think we cannot create ODBC link in Win mobile, then how can we access to
SQL server or other mobile DB engine?

Sorry, I am unable to fund a certain discussion group for basic VB.NET
questions...if you can direct me to the source it will be appreciate
it. However, I have one stupid question in terms of ListView and just
my luck I don't know how to solve that problem.

Hello all I am using VS2005/C#/SQLCE3.0. I am trying to insert and
retrieve a jpg image using the SQLCE 3.0 database. what I would like to
do is open a image file to a stream and insert that stream into the
database, I am thinking I am going to have to serialize/deserialize it

This is the code I am using:
Private Sub frmInventoryTransfer_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load
       Dim objConn As SqlCeConnection = Nothing

I looked in "ssceoledb30.h" and I saw these lines of code:
// PUBLISHED: Provider Specific Interfaces
// IID_ISSCECompact
// NOTE: removed as per raid 9395

I have a stand alone SQL CE database on my windows mobile device.
OS = WM 5 Dutch.
I can alter teh local database on the mobile device which will be used
by persons who will store data when they visit a client.

This kind of query works well with Access:
SELECT Field1, (SELECT Field2 FROM Table2 WHERE Key=1) AS Field2 FROM Table1
But when I try execute it with SQL Server Everywhere it says "Token in error
= SELECT".