Applications use the RDA object to access a database on a remote instance of Microsoft SQL Server Compact 3.5 and to populate a local SQL Server Compact 3.5 database with the data. The following table describes the methods that the RDA object supports.
Method |
Description |
|---|---|
Retrieves data from a remote Microsoft SQL Server database and stores that data in a single table in a local SQL Server Compact 3.5 database. |
|
Sends changes from a locally-tracked SQL Server Compact 3.5 table back to the original remote SQL Server table. |
|
Submits SQL statements for execution on a remote SQL Server database. |
Each of the three RDA object methods contains an OLEDBConnectionString property. This property provides the OLE DB connection string that is used when connecting to the remote SQL Server database. The OLE DB connection string provides connectivity information, including security information.