HI NG!
I have a query problem regarding a table which contains an integer primary
key. The problem is that I'm unable to search for this column properly.
I've used following SQL CE Statement:

I have Orders table with field OrderDate, so I have created row filter
like this
SELECT <published_columns> FROM [dbo].[Orders] WHERE OrderDate >=
DateAdd(week,-1,GetDate())

.NET Framework 1.1 sp 1
PPC application was fully functional until two weeks ago when firewall was
updated, IP addresses were changed, and 2000 Server was replaced with 2003
Upgrade from Windows 2000 IIS Server to 2003 IIS Server with .NET Framework

Hi, this is my first development project for mobile devices. I hope someone
can point me in the right direction and tell me software and tools i would
need to achieve the following.
1. A PocketPC 2002 would be connected to the local network using a Wifi

trying to install sqlserver ce in ce.net based PDA.
I've tried to setup SQL SERVER CE as i did on pocket pc os, but failed.

SQL CE Sync'ing with SQL Server 2000:
1)SQL on server on LAN
2) Active sync on desktop on LAN
3) Cannot sync through desktop to Server

When is there a way to automatically add foreign keys to my ssce database?
Just like it creates primary keys and indexes with
RdaTrackOption.TrackingOnWithIndexes I would like the foreign keys to be
copied as well.

Newbie here.  From what I've read it looks like the only way I can
create a database is to create a device application that creates one
through code and then run that application on a device/emulator.
I need to deploy a pre-populated database.  Is the only way to do that

I used OLEDB and SQL commands to create and modify a table.
The program worked fine at the beginning. Then I run such a command
'Alter table table10 Alter column  col2 SET DEFAULT 1.2;'.  It seemed still
fine. However, the debugger showed a crash error when the program was closed!

We are using the merge replication between SQL 2000 (SP3 -
8.00.760) and HPC (SQL CE) across internet using VPN. DLL
is SSCESA10.dll.
Everything was perfect till yesterday but suddenly getting

How many tables can I synchronize with SQL Server merge replication with a
SQL Server CE?
I found that there is a limitation about 32 indexes in merge replication,
can I have then more than 32 tables (supose each foreign key have an index)?

I have a small VB.net program that loads comma seprated values from a text
file and puts them into a SQLCE database.
However, the ntext columns do not get any data.The database has 1 table
called with 4 columns.

I am trying to implement encryption with password protection on my PocketPC
SQL DB.  I had everything working fine without the password but now I keep
getting a connection error.
I create the database as follows:

Here's my scenario:
User has an application on a laptop which stores data in an MSDE database
which then synchronizes to a central sql2k server.
User also has a PDA to enter data while mobile, data is stored in sql server

I've overheard that merge replication will not be supported anymore in next
releases of SqlServer CE.
Also would MS drop the use of SqlCE in favor of Xml files based solutions?
Given the slowliness to access Xml files in comparison with the same data