Comparing OLE DB and ODBC
ODBC (Open Database Connectivity) has been around now for many years and has allowed access to well-formed relational databases. It solves the developer's problem of how to access different databases easily from within an application. Now, from within an application you can access a delimited text file, a FoxPro database, and an Oracle database—as long as you have the proper drivers installed. Without ODBC, developers are required to know and understand the unique way data is stored in each of these systems.
ODBC is an international standard whereby drivers can be created to access relational data. This is why it is called open. As long as someone writes an ODBC driver for the data, developers can access the data through ...
Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
