Accessing ODBC Data Sources
Just as with the OleDb provider that ships with VS .NET, the Odbc provider is an example of a generic provider that can used to access a variety of data sources. As we discussed on Day 1, “ADO.NET in Perspective,” ODBC was a major advance in data access technologies because it standardized the way that clients access data by abstracting the data store specifics into an ODBC driver. Clients could then program against the ODBC API and rely on the ODBC Driver Manager to load the appropriate drivers on behalf of the application, pass queries to the driver, and manage aspects of the communication such as pooling connections. As a result, when using the Odbc provider, your application architecture appears as shown in Figure ...
Get Sams Teach Yourself ADO.NET 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.
