i have installed sp4 for sql 2000 and when i try to install server tools for
sql ce i've got an error "Only compatible..................", i'm using
windows 2003 and .net 2003, what can i do to solve this problem.

If I have a data table that contains 6 columns.
I want to display its data in a data grid, how can i display just the data
of one column in the data grid?
Thank you

is there any where to
a) Manipulate data on an PocketPC from the Desktop PC ?
b) Manipulating an SQL CE Database on an Dekstop PC with the standard
Framework. So that I can add data on the Desktop PC then transfer the whole

I want to display my data in a datagrid, i am bringing this data from the db
using a sqlCeDataReader. Now, after i have my sqlCeDataReader how to display
it in the datagrid?
Thank you

i'm working on SQL SERVWER 2000
i have replicated table and view (merge replica)
but whene i try to execute
"Insert INTO TABLE1 select campo1,..campoN from TABLE1 where recordnumber=

I am trying to determine the best field type to store richtext data with the
best performance on pocket PC devices.
Currently the data (richtext)can be entered on a desktop solution, and
synced to a PPC device. Can anyone suggest the best solution to this.

A client of mine has given me a SQLCE Database which has SQL Decimals
instead of Floats or Money which I'm used to working with. How can I
convert these decimals to doubles? I want to retrieve a value from a
database and then add it to a total I have on a form. I'm using VB.NET

can a SQL mobile DB be synchronised with MSDE,SQL Express or SQL Group work
group edition using RDA or replication
can a SQL CE DB be synchronised with MSDE,SQL Express or SQL Group work
group edition using RDA or replication

Hello NG,
how can I show a image from a SQLServerCE-DB (image-field) in a Picturebox?
I dont want save the image before on my PocketPC.
Thank You!

during a merge replication between sql server 2000 and sql server ce 2.0,
i'v an error after a long transfer time.
The error is : a read operation from the internet returned an incorrect
number of bytes.

I've been running a development edition of SQL2k with SP2 on it, and
replication works reasonably well. I'm rolling out the app to an SQL2k
installation with SP4 on it. Any caveats or issues with SP4 and SQLCE?

I have an odd situation. I am using RDA to pull data from S2K into SQLCE on
PPC using 3 stored procedures. 2 of these work fine, but with the other  
there is an odd issue regarding the use of a column name 'Origin_ID' which is
a tinyint

We started to have very strange situation the field. It looks like ADOCE
Connection.Close method doesn't free handle to the file.
DB file can not be opened by other programs while our application is running
(but closed connection to that DB!!). It worked perfectly well some time

Please which perform better for searching in a sql ce db table:
1) using an sqlCeAdapter and querying the table then loading a datatable
with sqlCeAdapter and bind it to a data grid or
2)Loading the datatable using the sqlCeAdapter with all the table data then

SQL CE 2.0 update (Server tools for replication) to work with SQL 2000 SP4
is released.
It can be downloaded from
http://www.microsoft.com/downloads/details.aspx?familyid=79071E22-52F5-4189-998E
-FD03648FD3F4&displaylang=en