The ActiveX Data Objects (ADO) has been useful in database management systems for connectivity and data manipulation. Many past application utilize this level of technology. Microsoft has announced that it will drop support for this ADO DBMS technology in the near future.
I have decided to leverage the component architecture of Delphi’s Visual Control Library (VCL) and employ a component set that replaces the ADO function.
The main advantage to this approach is the ODBC infrastructure is no longer required, Therefore DSN’s and UIL’s are no longer required. The replacement ODBC is to correctly replace so the aforementioned overhead is no longer required.
All features of ADO are available in the new VCL self-contained DBMS. The new technology also provides support for most of the popular DBMS’s like MySql, Oracle, SQL Server and others including Access. In all there numerous DBMS infrastructures supported and none of the require the ODBC overhead.
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems authored this article.