I have a problem with order by of numeric field.
I'm using SqlCE version 2.0.
I created new database with general collation.
I created new table with this script:

I've a database with 5 tables. I want to create a publication of the
whole database to make a syncronization with sqlCE.
Is it possible to create a unique pubblication, or do I have to create
one pubblication for each table?

I had previously posted this in
microsoft.public.dotnet.framework.compactframework but was told to post here
so sorry it is seen as a duplicate post.
I was also asked to post the schema and query, the query is below but how do

I have a smart device application written in VB .NET. I am using the .pull
method to get the data from a SQL Server on my desktop to the database on my
device. The RDA pull method works great and my tables are being created on
my device. However, I want to code my program so that if ...

I have an PPC app that i developed to talk to sql server instance on my
internal network - e.g. I used internal IP of 192.168.0.1, but when I
switched to Public IP (Port 80 traffic mapped to 192.168.0.1 using my
firewall) it gave me an error when trying RDA.pull saying that access

Hi guys! We on OpenKnowledge a software design company in Puerto Rico develop
a PDA application that read barcodes and check if the barcode is on file on
checking on the SQL CE Database. The application can sync with a remote SQL
Server where upload and downloads the data.

I wrote a desktop application with a SQL Server 2000 database and a mobile
application for PocketPc with a SQL Server CE Database and I realized a
replication mechanism that when the user presses a button on the PocketPc
application the data will be synchronized via WLAN and the ...

I want to use sqlce with two servers:
server1 => Windows 2000, IIS, SQL Server CE 2.0 Server Tools
server2 => Windows 2000, SQL Server 2000
using SSL and Windows Authentication

In creating a new SqlCeReplication object, does SQL Server CE support a
string InternetURL value which uses the HTTPS protocol?
Thanks,

I have a table named FMACLI with Primary Key: enterprise,customer
I have following instructions in my application:
......
Dim cn As New SqlCeConnection(sConnectionString)

Hy, i'm trying to update a table with a DataAdapter on sql server ce.
I assign to the dataadpter the commands generated from the CB, but i
Receive a 25501 native error (Unable to parse the query)
So, I've tried ti execute an sqlcecommand with the sintax used from

I would like to know how to use OleDB IAlterTable.
I'm currently working with database SQL Server 2000 CE and Access 2000 and I
need to be able to rename a table.
I just don't know where to start.

Would it be wise to have 350 users running off one publication? Or...
As part of getting a plan together to tackle scaling a particular
architecture we were also thinking of dividing our database into units and
putting separate publications on each and having our users get 3 ...

Is there a way to know if a table already exists inside a database?

This document seems to indicate that indexes will improve performance
"tremendously," when used correctly:
http://support.microsoft.com/default.aspx?scid=kb;en-us;274112
However, I have not been able to find any solid confirmation of whether SQL