I have a doubt about the use of the OLEDB, I know that I can't use it
direct at the .NET and that the use of this is in VC++, but my question
is if I need to make a big insert of data at my tables the use os this
connection will help me to win speed to insert ? or I will get the ...

I've got an app written in Win32 C++ OOP non-MFC.   This app uses ADOCE3.1
to interface with a Pocket Access CDB file.   I'm thinking about replacing
PocketAccess with SQLce and continuing to interface to the DB via ADOCE3.1.
I want to stay with the eVC3.0 development environment, ...

Hello...
I have a .Net CF 2.0 app that is using Sql Mobile and it replicates data
between the client and a sql 2000 server.  This works great.  The replication
occurs in the background...we are using the provided sql mobile methods to

At my project I want to use the parametrized query to win any seconds
to run a query but at this point I have a problem, in the original
query I have:
SELECT .... FROM table WHERE column1 IN (12,13,24)

   I have a problem with varchar, i am concat n variables varchar for
stored in field type of text.
   The problem is that at concat this variable type varchar, the value
stored in the database is trucanta,

I'm doing merge replication between SQL Server 2000 and CE running on a PDA.
The PK of the tables are all uniqueidentifiers with a default value of
newid() and the IsRowGuid property set to true.
Immediately after application code running on the PDA executes an INSERT

hello need to clarify something. can sqlce2 do batch querries?
thanks in advance

I use SQL Ce Merge replication with horizontal filters (based on
SUSER_SNAME()) to transfer data from and to the device.
It works fine, but each time a synchronisation occurs, a new merge agent
appears in the replication monitor.

How can I get the default value for a given column in a given table and set
it for a column in a dataTable?

I typically write/use a code-generator whenever I need to access
a database. The code generator outputs classes that hide the
ugly details of the paticular database API. They can expose the
columns through strongly typed Get/Set members, provide query

I want to know if there is a way to keep a "log" of all the record going to
the SQL Server from SQLCE thur either RDA or Merge Replication.
What I want to do is to have a log ready when for some reason the
synchronization failed, I would be able to debug it from the lower level. ...

I have a two part question here. My application requires data to be loaded
regularly. On some occasions, the data can be fairly sizeable, requiring
several
minutes of running Insert statements. We're talking thousands of inserts,

My question consists of two parts.
1) When I do RDA, is the relationship preserved? What about Merge Replication?
2) I have a table which contain an ID column. Initially, there are records
(say 10 records) in the table on the SQL Server side. I performed a PULL (or

I have an application that uses SQL CE. I have installed the application on
several pocketpc's of different brands (siemens, qtek, dell, ...) and
different os (win2002, 2003, 2003se)
I now have a customer with a QTEK2020i (mind the 'i') and on this pocketpc I

i want to develop a winCE application with database support through sql
server ce/mobile, but I don't want to pay for every sold version of that
software.
The application will not communicate with a sql-server on desktop side. It