ole datareader和odbc datareader之间有什么区别 [英] what is difference between ole datareader and odbc datareader

问题描述

我需要知道ole datarader和odbc datareader的优缺点和功能

i need to know ole datareader and odbc datareader of advantage and disadvantage and features

推荐答案

OLE DB [ ^ ]是一种非常通用的方式来访问以不同格式存储的数据。通常，数据以表格格式存储。数据源可以是数据库，excel文件等。



ODBC [ ^ ]然后再次更专门设计用于访问并操纵数据库中的数据。



话虽如此，与OLE DB相比，ODBC连接可以更高效，尤其是在ODBC类使用ODBC驱动程序中设计的功能的情况下。使用与更通用的OLE DB相同的功能甚至是不可能的。



ODBC也有数据源的定义，可以是用户级别或系统级别。因此，有一个额外的抽象层，可以使用Windows控制面板进行配置。

OLE DB[^] is a quite generic way to access data stored in different kinds of formats. Typically the data is stored in tabular format. The data source can be a database, excel file etc.

The ODBC[^] then again is more specifically designed to access and manipulate data in databases.

Having that said, ODBC connection can be more efficient compared to OLE DB especially in situations where ODBC classes use functionality designed in ODBC driver. Using the same functionality with more generic OLE DB may even be impossible.

Also ODBC has a definition of a data source which can be either user or system level. Because of this there is an extra abstraction layer which can be configured using Windows Control Panel.

这篇关于ole datareader和odbc datareader之间有什么区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！