The following sections provide you with some simple tasks that can be accomplished by using ADO. The intention of this section is to bring out the differences between ADO and ADO.NET.
You can connect to any database that supports Open Database Connectivity (ODBC) through APIs. Apart from databases such as Oracle, Access, SQL Server, and Paradox databases that are ODBC-compliant, you can also access Excel spreadsheets and delimited text files, which also are ODBC-compliant. ODBC has a shortcoming in terms of not being able to fully encapsulate low-level programming.
A delimited text file contains data separated by special characters, such as tab and newline characters. When an application reads data from the text file, it ...