Remote Data Access
Now you’re in the home stretch. You’ve learned about the inner workings of SQL Server CE and how to program against it with ADO.NET. These final two chapters will take you outside the database and show you how to securely move data back and forth between SQL Server and SQL Server CE. Not only that, you’ll be able to add new data and change existing data on your Pocket PC and see those changes and additions reflected on the server. At the beginning of the book, I discussed some things that you don’t usually see in a computer book. Remember those FBI agents working in Phoenix and Minneapolis who couldn’t get their critical field memos to the right people in Washington, D.C. before 9/11? Well, in this chapter and the next, you’re going to build a system that will facilitate the creation and movement of simple field memos between a Pocket PC and a SQL Server. I’m not a business intelligence expert, so I’ll leave it to someone more qualified than myself to implement a data mining system to analyze these memos in order to connect the dots. In this chapter, I’m going to cover doing this with a technology called Remote Data Access, or RDA for short. Compared to the next chapter’s coverage of merge replication, RDA is relatively easy to get up and running and works with SQL Server versions 6.5, 7.0, and 2000.
KeywordsCertification Authority Proxy Server Secure Socket Layer Client Agent Query Analyzer
Unable to display preview. Download preview PDF.