The odbc net data provider is an add-on component to the net framework it provides access to native odbc drivers the same way the ole db net data provider provides access to native ole db. Download net framework data provider for odbc. To connect with an odbc driver, start by selecting the net framework data provider for odbc as the data source on the choose a data source or choose a destination page this provider acts as a wrapper around the odbc driver here's the generic screen that you see immediately after selecting the net framework data provider for odbc.
download .net framework data provider for odbc
The net framework data provider for sql server uses its own protocol to communicate with sql server it is lightweight and performs well because it is optimized to access a sql server directly without adding an ole db or open database connectivity (odbc) layer. Remarks. the .net framework data provider for odbc describes a collection of classes used to access an odbc data source in the managed space. using the odbcdataadapter class, you can fill a memory-resident dataset that you can use to query and update the data source.. for more information about how to use this namespace, see the odbcdatareader, odbccommand, and odbcconnection classes.. This means that virtually every odbc driver can be used through this class library. the .net framework data provider for odbc supports both local and distributed transactions. for distributed transactions, the .net framework data provider for odbc, by default, automatically enlists in a transaction..
get link reference

0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.