![]()
CoDA widens your options for accessing data within the enterprise. It provides Common Data Access in the form of a simple protocol that enables any networked device from workstations and PCs to palm computers and mobile phones to communicate with any data store without requiring numerous drivers.
The main component is a server application that presents a uniform interface to the underlying database meaning that only a single client driver is required. For "Fat" clients that support ADO or ODBC this may not seem an advantage aside from a cost saving by avoiding a full Enterprise version of the development software. The great benefit is to "thin" clients, particularly mobile devices, where no existing drivers exist or have too large a memory requirement or to platforms where only expensive commercial drivers are available.
Two protocols are supported- both based on HTTP. The first is a very simple delimited string allowing new a new client library to be written rapidly. The second is an XML based stream.
Unfortunately, differing SQL dialects may still mean small changes to the query strings input.
July 2002
The priority items are to move the Windows application into a Service and add Oracle support.
Please check back for progress updates, particularly binaries and the published protocols. If you are interested in the project and would perhaps like to offer support for a database or platform please email archie@zymosis.co.uk.