I have a table 'test' with a column 'testdate'  as nvarchar(50).
The data this table are datetime values:
10-01-2005
11-01-2005

Can I use MSDE as publisher and SQL CE as subscriber? Should We buy any
license? We don't use SQL Server at all
Andrea Aiello

I reading the sql database from the sqlcedataadapter to a dataset , from the
datatset i fill a datatable and than i assign
that datatable to a datagrid.
Each replicable user table created on your device has these three

I'm trying to sync between sql ce and sql 2000.  I'm not using an IIS server.  What is the best way to get this don't using vb.net 2003.  Any code examples?
Thanks
Terence

I have reseted my pocket pc when the connection between the database and my
application was enabled yet, but, I am still not sure if I can assume that I
will be able to open the database again after doing it. Please, could anyone
tell me if I

Hi,
My RDA application was running fine. I added some more tables for pulling
(Total 45 tables are pulled). Now application works fine when i sync it over
LAN (both from Emulator and PPC). Syncing from Emulator via Internet works

I am devoloping an application for PPC with Visual Basic .NET and SQL Server
CE. The thing is I use a database that was designed in Access 2000. I
couldn't find an easy way to import the database (from Access to SQLCE) so I
wrote a routine in VB that, through ADO builds the ...

Can someone tell me what does this error message mean and how can I solve it?
Thanks in advance,
Stavros Makridis.

I am developing a OLEDB application where in am able to get the value of all types but while inserting also i make it work for sting data type. like this instaed of called command.setvalue i used the following code:
    cmd1.TranslateColumnNo(lCol);
        void ...

after some trials and tribulations i have "found" several things that have
given me some grief in my application design and i am wondering how people
have got round it.
my plan was to use rda to push data back to the sqlce database into a temp

i am trying to rda.pull a sqlserverce 2.0 from an app i created in c# on
pocket pc 2003.
When i try to pull i get these errors:
Error Code: 80004005

I would like to import data from an XML file to a table in SQL CE directly
if possible.  I've seen some examples of populating a dataset and then
importing to the table from that dataset, but would like to skip that step
for memory reasons, etc.  Is it possible?

Sorry everyone, if my question is too lousy.
But I still want to know, how do I deploy SQL CE 2.0 on new device? I don't
know, I installed my Visual Studio .NET 2003 Professional, and few others
toolkits, "magically", I get my SQL CE on that device and working.

I am developing a OLEDB application where in am able to get the value of all types but while inserting also i make it work for sting data type. like this instaed of called command.setvalue i used the following code:
    cmd1.TranslateColumnNo(lCol);
        void ...

My 2nd question. I use a conveter (PocketSync) and it helps convert my MDB
(Access) to SQL CE, but without creating any indexes.
My concern is that, without indexes will the SQL CE operates slower? Very
much slower?