I have the following code in my application,but when I compile VS tells me
that SqlCeDataAdapter does not contain a definition for Fill?
ceDB.Open();
SqlCeDataAdapter da = new SqlCeDataAdapter();

There must be a simple answer to this, excuse my ignorance.
I have 2 related tables with the primary key for Table1 being of
auto-increment type (1, 1) and the foreign key in Table2 that references it
being of type integer.  I have set up a FK/PK relationship.

I have SQL CE database (.sdf file) and want to transfer it
to MS SQL Server 2000 (.mdf file).
Is there any solution to do it in relatively simple way (without
creating database with corresponding tables on SQL Server 2000).

I'm using merge replication with dynamic filters.
The replication works fine for a couple of times but after that I get Error
80045063: "Failed to enumerate changes in the filtered articles" ->
"sp_Mssetupbelongs"

I have a PPC CF CE app that uses RDA to pull data from SQL Server 2000 db.
I'm trying to document what is needed to set IIS up for RDA.
From this I'm outlining minimum software/hardware requirements.
The VS2003 automatically installs SQL Server CE on the PPC but what kind of

I'm using vb.net with a SqlServer Ce database and I'm trying merge
replication with SqlServer 2000. I've configured everything (IIS, SQL server
publisher), etc. but I have an error when I do"Synchronize"
System.Data.SqlServerCe.SqlCeError: An incorrect or unsupported HTTP

I can't find what is wrong with this statement. It is very simple and is getting me frustrated.
Update Test_PPC SET WDC = '554765', User = 'Smith, Mike', SID = 'B455752' WHERE AKEY = '841000004'
All of the data types are nvarchar(250) except for AKEY which is nvarchar(12). Is User ...

I also use the PocketPC Emulator. I don't have a real device yet.

How can I check if some database is already created?

Is it possible to insert more than one record with one request (i'm using
ADOCE) ?
I've tested the following syntax, but it doesn't works :
INSERT INTO MYTABLE (FIELD1) VALUES(100), VALUES(101)

I am using SQL server CE 2.0 with servicepack 3.0 to connect to sql server 2000
While making query to the SQL Server CE i am getting parse errors. The case is when i use "Case" or "Cast" or "Convert", SUBSTRING etc.
Like to know does Ce supports these sql functions.(It is given in ...

I need advise. Where can I find more info regarding the
above-mentioned. I have read Microsoft's
article: "Microsoft SQL server 2000 Scalability Project -
Server Consolidation", regarding running multiple

I am trying to perform a "Merge Replication" from the PPC simulator with
VS.net 2003. Has anyone experienced this before or have any resolution?
the SQL Server publiation  is setup on another machine which also serves as
the SQL Server CE Agent (configured with anonymous access only ...

here is my code,
string str ="Provider=sqloledb; Data Source=BART;Initial Catalog=rdaMobile; User Id=sa;Password=";
rda.InternetUrl = "http://BART/VirtualSQL/sscesa20.dll";  
rda.LocalConnectionString =@"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data  Source=\\My ...

we are having a big problem using SQL Server CE 2.0. Before running our
program about 10 MegaBytes of memory are used on our device. The programm
creates a database and inserts data. After closing the programm about 12
MegaBytes (depending on how many data was inserted) are marked ...