O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

8.3. Staying with OLE DB: Interaction with the OleDb Data Provider

ODBC and OLE DB providers have the advantage of being directly hooked into other Microsoft and third-party products. Microsoft Access, for example, can use any ODBC driver to directly expose data as though it came from Access databases, for use by Access applications. SQL Server permits OLE DB data sources to be used in distributed queries. SQL Server 7.0 and later can also use any OLE DB provider to import, export, and transform data with its Data Transformation Services feature. Crystal Reports can use ODBC drivers or ADO Recordsets for input to reporting. Other products generate OLAP data or XML schemas from existing data sources through ADO or ODBC.

These and other examples ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required