Source: http://blog.9cbs.net/LYA_LYA/Archive/2004/08/13/73908.aspx
ADO Universal Data Access (UDA) is part of Microsoft, which provides the ability to quickly access various databases, and UDA provides an unrestricted capacity, accessing various data sources through easy-to-use API interfaces, of course, this Requires a driver compatible with it, similar to Delphi's BDE, which can easily access data from a variety of data sources in a program. UDA is implemented with MDAC, while MDAC includes Active Data Objects (ADO), Open Database Connectivity (ODBC) and OLE DB.ADO is a MDAC's application design interface. OLE DB is a system-level interface, defining a set of COM Interface, providing data access capabilities from the associated database and file system, ODBC is also included in MDAC in order to backward, but in the future, he is replaced by OLE DB, now for ODBC, developers use ODBC drivers through ADO Despite this, OLE DB has been available for Microsoft Access, Microsoft SQL, and Oracle.ado. Another important advantage is that all operating systems that are built-in in Microsoft will not, including Windows 2000, which means that although now in order to use ADO To access the database and have to install ADO in each PC, this installation technology will disappear in the future. If you want to learn from UDA and ADO, you can access Microsoft's data access home page http://www.microsoft.com/data/default.htm, from this homepage, not only to Adoredistributable, you can use him in Windows95 / 98 / NT installation ADO, can also get the MDAC's SDK, including full documentation, and all tools that need to develop its own OLE DB, in addition, SDK also contains ADO release. Each thing you need with ADO is made on the installation disk of Delphi 5. If you install MDAC, make program MDAC_typ.exe. Since the installer is only one file, the MDAC has also become very simple. If your own application needs to install MDAC, this installer can also serve as part of the installer of its own development, in order to remove its installation prompt information, you need to use the following command line when the homemade installer: MDAC_Typ.exe / Q: a /c:"setup.exe / qt "For more information on MDAC, icon list and dependencies, you can see the MDAC SDK document. Using Adoconnection and Adodataset control D5 provide a new control to support ADO, and can easily convert existing applications to ADO, build an ADO application, first need to put an Adoconnection control in Form or Data Module, this is The BDE's Database control is almost, he allows the connection with the database through the connectionString property, if you want to handle this coupling string is not an easy task, this string is a series of parameters separated by ';', these parameters are easy. You can more than 150 characters, lucky is that Microsoft provides a joint string editor to make this income simple. In order to open this editor, you can complete this work. Cool.
