Microsoft Remote Data Service
What's New in Remote Data Service
Getting Started with Microsoft Remote Data Service
Setting Up Remote Data Service
Setting Up
Other RDS Configuration Information
Getting Assistance While You Work
Introduction to Remote Data Service
Sample and Demo Applications
Tutorials
Tutorial: Building a simple Remote Data Service Application
Tutorial: Building a simple Remote Data Service Application
Identify the database
Insert the Grid and AdvancedDataControl Object
Add HTML Controls
Add Code to Send a Query to the Database
Add Code to Submit Changes to the Database
Add Code to Move through the Displayed Recordset
See the Code in Action
Tutorial: Address Book
Running the Address Book Sample Application
System Requirements
Setting Up an ODBC Connection
Running the SQL Script
Code Overview
HTML Framework
Text Boxes
Command Buttons
Data-Binding Control
Data Grid
Navigation Buttons
Initialization
Complete Source Code
Remote Data Service Developer's Guide
Understanding Remote Data Service Applications
Three-Tiered Applications
How does a Remote Data Service application work?
Client Tier
Remote Data Service Web Pages
AdvancedDataControl Object
Business Object Proxies and AdvancedDataSpace
Client-Side Data Cache
ActiveX Data Objects
OLE DB
Client Cursor Engine
Middle Tier
Internet Information Server
Business Objects
Server-Side Data Cache
Data Source Tier
Data Source Tier
Developing Remote Data Service Applications
Getting a Recordset to the Client
Using the AdvancedDataControl Object
Asynchronous Population
Using the AdvancedDataFactory Object Manually
Using a Custom Business Object
Writing Code to Pass Recordsets with a Custom ActiveX DLL
Required Custom Business Object Registry Entry
Marking Business Objects as "Safe for scripting"
Client-side Registry Entries for Business Objects with DCOM
Custom Business Object Launch Parameters
Transport Protocols
Connection Pooling
Using the IIS Connection Pooling Option
Using MTS Resource Dispensers
Running Business Objects in Transaction Server
Passing Updated Recordsets to the Middle Tier
Using AdvancedDataControl
Multiuser Issues
Database Updatability
Defining Recordset Shape
Sorting and Filtering
Sorting a Recordset
Filtering a Recordset
Navigating Through Recordsets
Using Bound Controls
Appendixes
Appendix A: Troubleshooting Remote Data Service
Appendix B: Detailed Control Flow
Remote Data Service API Reference
Objects
AdvancedDataControl Object
CancelUpdate Method
Connect Property
CreateRecordset Method
MoveFirst, MoveLast, MoveNext, MovePrevious Methods
Recordset Property
Refresh Method
Server Property
SourceRecordset Property
SQL Property
SubmitChanges Method
AdvancedDataFactory Object
CreateRecordset Method
Query Method
SubmitChanges Method
AdvancedDataSpace Object
CreateObject Method
Methods
CancelUpdate Method
CreateObject Method
CreateRecordset Method
MoveFirst, MoveLast, MoveNext, MovePrevious Methods
Query Method
Refresh Method
SubmitChanges Method
Properties
Connect Property
Recordset Property
Server Property
SourceRecordset Property
SQL Property
Appendixes
Error Codes
Tested Data-Aware Controls
Remote Data Service Glossary
Remote Data Service Glossary
Sample Applications