SSCE 2 and RDA

[AAVarda]

Hi all,
There is a server with
-Windows 2003 Enterprise Edition
-SQL Server 2000
-IIS

I am trying to use Remote Data Access to scyn my data collector with the
above server BUT it fails...
My Data collector has
-.NET CE
-SSCE 2

But the above data collector successfully sync with my office server which
has
-Windows 2000 Advance server
-SQL Server 2000

Q1. CAN you tell me what are the pre-requirements for setting up RDA on a
Windows 2003 Enterprise Edition.?
Q2. What port is activesync using so that I can bypass the firewall by
setting up exception in firewall CAUSE I have to always turn OFF my firewall
before using RDA.

Thanks in advance...
AA Varda

 

[Darren Shaffer]

if RDA is failing for you, catch the exception and pls post the
HRESULT so we can troubleshoot that. you can control the
port that is used for RDA (typically 80 or 8080) by specifying
it in the connection string to SQL Server in your RDA code.
You'll then need to open this port in your firewall.

also - there is a newsgroup for these sorts of questions
at microsoft.public.sqlserver.ce

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

 

[AAVarda]

Thank you...I will get back

if RDA is failing for you, catch the exception and pls post the
HRESULT so we can troubleshoot that. you can control the
port that is used for RDA (typically 80 or 8080) by specifying
it in the connection string to SQL Server in your RDA code.
You'll then need to open this port in your firewall.

also - there is a newsgroup for these sorts of questions
at microsoft.public.sqlserver.ce

--
Darren Shaffer
.NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com