[DotNetDevelopment] SQL Server CE RDA through Activesync

[JaffaB]

All,

I am trying to make a program in VS which will sync a SQL Server CE
database on a pocket PC with a server based SQl Server database
through activesync.  However, can anybody tell me if there is a way to
get the RDA to function through a client PC.

So, the PPC (device 1) is docked via activesync, which talks to the
client PC (device 2), which itself has access to the server on the
network which holds the main SQL Server database (device 3).

In the SQL CE RDa connection, can I do this.  When activesync is
running, will the PPC (device1) automatically be able to see the
server (device3), or do I have to set up a proxy connection somehow
(if so, how?).

Is this even possible?  All the examples I have seen on RDA talk about
the database being on a client machine.

My code is as follows:

                        string url = 
string.Format("http://MINSERVER/RDA/sscesa20.dll";);
                        using (SqlCeRemoteDataAccess rda = new 
SqlCeRemoteDataAccess
(url,"", "", sConnectionString))
                        {
                                try
                                {
                                        rda.LocalConnectionString =
"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\\My Documents\
\LocalDatabase.sdf";

                                        //
                                        //      Process and pull the abort 
reasons table
                                        //
                                        string pull = string.Format (
                                                "SELECT * from BT_ABORT"
                                                );
                                        rda.Pull ("BT_ABORT", pull, 
sConnectionString);

Regards

Jaffa