Kamiak ADOis a library of Delphi database components. It includes TDataset descendents so that you can use it with VCL data-aware components. Because Kamiak ADO uses Microsoft's ActiveX Data Objects to access data, the BDE is not required. Using ADO, you can connect to any Ole DB provider. Currently Ole DB providers exist for SQL Server, Oracle, Access, ODBC, Active Directory Services, and the Index Server. Kamiak ADO components include extensive design-time property editors that make setting properties easy, and allow viewing of data at design-time.

With Kamiak ADO, you can also exploit the power of Microsoft's Remote Data Service (RDS). RDS is a portion of ADO that allows remote access to data over both trusted networks and the internet, and provides a cursor engine for working with disconnected recordsets. In essence, it allows one to create recordset objects, and pass them around as function parameters. RDS takes care of marshalling the recordsets over DCOM, http, https, and in-process connections. This in turn lends itself to conventional client-server and N-tier client server systems. Middle tier business objects can create recordsets and pass these over networks to thin clients. Kamiak ADO provides native Delphi support for RDS. It does so in an open and flexible way. Business objects created with Visual Basic can be combined with client applications created using Kamiak ADO and Delphi, and vice versa.

Components for Desktop Data Access

TkamAdoConnection: Encapsulates a connection to local Ole DB provider. Design-time property editors permit allow easy selection of the provider and

TkamAdoTable: Encapsulates a table in a local database.

TkamAdoCommand: Encapsulates an Ole DB command string (such as SQL) and the resulting recordset.

TkamAdoSchemaInfoTable: Encapsulates a rowset of information about a database. Allows database information such as tables, columns, indexes, views, etc. to be accessed as TDatasets and displayed in VCL data-aware controls.

TkamSourcesTreeView: Displays a hierarchical view of all Ole DB providers on the local machine and their data sources.

Components for N-Tier Distributed Systems.

TkamBusinessObjectProxy
Acts as a client-side proxy for a custom business object running on the server.

TkamDataFactoryProxy
Subclass of the TkamBusinessObjectProxy. Acts as a client-side proxy for the one business object built into server-side RDS. This built in object passes SQL or other command text through to the backend, allowing easy creation of two-tier client server systems.

TkamAdoClientDataset
Thin-client dataset. Uses client-side Remote Data Services of ADO to provide the cursor engine for disconnected recordsets.

TkamUpdateApplier
Used in middle tier business objects to automatically apply changesto the back-end. When a disconnected recordset is passed to the client tier, is edited, and then returned to the middle tier, this component can be used to apply changes to the back end.