I am developing an application for Pocket PC that will house data in a local CE database on the Pocket PC. I have a few question before I finalize my approach; I plan to use RDA (Pull and Push) from and to a Master SQL 2005 database hanging off a DMZ; the IIS server will also hang off the same DMZ and will be accessible from the outside world by a global address (no DNS). My question is during the RDA Pull, can I bring over the database structure only from the Master SQL 2005 server (no data)?
Secondly, I have yet to receive the Pocket PC model that will be used and I have to use the VB2005 emulator; how can I get the pocket pc to see the IIS (sqlcesa30.dll) website? It is posing quite a challenge in the beginning stages of the design. I am unable to test the RDA functionality because the pocket pc emulator cannot access the IIS server via the browser.
Lastly, could you provide me with an example of the (3) connection strings that I will need in the application (to master 2005 DB, to local pocket PC DB, etc)
Your Assistance is GREATLY appreciated.