I need to limit the number of records returned in a recordset from SQL
Server CE to my .NET CF application.   Naturally I first tried SELECT TOP
but as many of you probably know that doesn't work!
Unfortionately I can't really narrow down the result set with WHERE clauses

I have this project for developing an  drug interaction aplication for a pda
under a windows o.s .
The aplication is being developed on visual basic .net (using visual studio
.net 2003), and I needed to create an local datastore, the problem is that

I want to delete the entry of one field in a row. Can anybody explain me how
I can do that?:-/
mathon

Is there anything similar to the RAPI interface that allowed me to call into
the CE Object Store from my desktop application (for reading and writing to
it) for SQL CE?  I have it working where I can connect the PocketPC to the
backend SQL Server on my server using wireless but I ...

I have designed a solution with merge replication with SQL 2000 as
publisher and MSDE 2000 as subscribers. This solution went into the
production some time ago and at the begining there were some problems
with downloading the data from the server at synchronization. The

I can install on a PC the server tools ("Configure Connectivity Support in
IIS" ) of sql server ce 2.0, or there are of the limitations.
I can include in a my package of installation the file of installation
unloaded from Internet on the microsoft site.

hi, i have this situation, i have a transaction table and a transaction
detail table, normally i would have an identity and use that identity to
insert the details in the other table
for example

I'm receiving this error from SSCE 2.0 when trying to insert a new row.
Error Code: 80004005
Message: The new value generated for the inserted row does not fall within
the allowable range. [Generated value,,,,,]

I'm trying to install the SQL Server CE Server Tools on a W2K3 server box
running SQL SP3a.  The CE tools have never been installed on this box before.
I got the message telling me I need to use an installer version that's
compatible with my SQL Server version so I downloaded the ...

I have created a prebuilt sql server ce database via VS 2003 and SQL Server
2000 using merge replication (which i intend to distribute initially w/ my
install program).
My question is: What is the easiest way to encrypt (password protect) this

I understand from a newsgroup posting by Debra Dove in June of this
year that there is a patch for SQL CE 2.0 available from PSS that
helps to mitigate the problem of slow sync times over poor (e.g. weak
signal GPRS) connections.  Please could someone contact me to enable

I'm trying to limit the number of records pulled to some tables to 0 records,
as I don't need the data from the server on my device, but I want to push
data back, so am forced to first do an rda pull with tracking on. So I try to
do it by creating a query that will not return any ...

 My requirement is to retrieve additional tables from 2 different
databases.
table 1 contains 10 records.
table 2 contains 5 more records along with table 1 10.

I have created an ODBC user and system data sourse and
specified Windows NT authentication for verifying the
authenticity.The following is the code i have used for
remote connection:

I've notice that when you execute a data reader on a connection after the
data reader is closed the connection status (actually StateIternal visible
only on debugger remains 9 witch is ConectionState.Open |
ConnectionState.Fetching). The first operation executed on the connection ...