I've put some effort into a project using the ATL OLEDB templates as
"ported" to Windows CE here:
"Using the ATL OLE DB Consumer Templates on the Pocket PC"
By Jo?o Paulo Figueira

We have an error log on our handheld system in SQLCE. The table is
created as follows:
CREATE TABLE Errors (
  ErrorTime datetime DEFAULT GetDate(),

I am using Merge Replication between SQL Server 2000
and a SQL CE device on a Windows Server 2003 box.
I know that I need a SQL Device CAL, but do I also need
a Windows Server CAL?

I updated Windows Small Business 2003 to Win Server 2003 Enterprise Edition
I installed SQL 2000 SP1 on it
And then I installed the soft Crystal Reports V.10
I configured IIS6

Hi Prasanna,
Ur reply for this post really worked for me. I am able to run my
NorthWindOleDb sample on PocketPC 2003 emulator. I am really thankful to u
for such an useful information.

I am trying to select information from a table using the follow but I get a
'system.data.sqlserverce.sqlceexception' error. The startDateTime and
endDateTime columns are datetime and the periodcode is int.
"SELECT startDateTime, endDateTime FROM driverData WHERE periodCodeId = 2

I'm repairing a program for one of my customers that was written by a
very untalented competitor.  One part of the program needs to do a
lookup on a table with 2 million records.  The original programmer
decided to break the table into twenty smaller tables.  In fact, he put

I'm repairing a program for one of my customers that was written by a
very untalented competitor.  One part of the program needs to do a
lookup on a table with 2 million records.  The original programmer
decided to break the table into twenty smaller tables.  In fact, he put

"Header information is either corrupted or missing." exception when
trying RDA.Pull().  Connecting to Sqlserver 2000 sp3 with sqlserver ce
2.0 (using the right dlls to match sp3).  No firewall involved.
Any thoughts?

When I click on the icon for the SQLCE Query, I receive the error message:
"Cannot find 'isqlw20' (or one of its components).  Make sure the path..."
I can even see the icon for it under the File Explorer (\Windows\SQLCE 2.0),
but it doesn't have the .exe extension and it has the ...

I try to find any information about INSERT, UPDATE and DELETE detection
in SQL Server CE. I try to write simple data synchronization software
(don't want to use replication and RDA mechanism).
Is there any flags, "transaction logs" or system tables where this kind

when i want to disconnect and after again connect the database,m
program gives this error.why this is happening,i am sure i am able t
disconnect from database
there is a file sharing violation.A different process might be usin

   This is probably a very basic question for most of you.  I've developed
in the past for the PocketPC 2000 and PocketPC2002 OS, creating appsin eVB
3.0  that used "PocketAccess", or CDB files.  To get a database table from
the PocketPC to the desktop PC, you just called ...

I'm having trouble performing a seek using the SqlCeResultset.
I've set the indexname command object to the primary key index name, I can
execute the resultset, but when I try to seek a record to update it I get:
"Seek/SetRange requires that you specify table index on the ...

Im VERY new to embedded application development and Im trying to run the NorthWindOleDb sample using EVC++4.0 and SQL Server CE 2.0 on the PPC 2003 emulator
I've managed to compile the code after installing the hotfix (with 3 warnings) and the emulator starts, but when i try to ...