Windows Mobile direct connection with Desktop SQL 2005 server

Originally Posted by johandekroon

I am relatively new to .net and SQL server 2005 but I am creating an application which runs on a handheld. The application needs to retrieve information from a MS SQL Server 2005 database. It shall have a simple database locally.

I think this should be possible in several ways
1 - handheld in the cradle and then connect using the desktop computer and active sync.
2 - Connect to internet and use a VPN connection
3 - Directly connect to the Server PC by connection the cradle to the server PC.

I do not want to install the IIS server on the SQL server so RDA or other synchronization methods of Microsoft cannot be used.

Then there is also Microsoft Synchronization Services for ADO.NET but I do not know what it exactly is.

Who can help me with this before I make a choice what to use and how to implement things.?