![]() The provider transforms incoming OLE DB calls into ODBC calls, and transfers them on to the specified ODBC driver. MSDASQL allows OLE DB consumer applications to use ODBC drivers to connect to a data source. The diagram below explains the flow of connecting to a SQL Server database using the MSDASQL provider and a SQL Server ODBC driver. In this article, we will explain how to install the appropriate ODBC drivers for SQL Server, how to configure ODBC to connect to a SQL Server instance and how to create and configure a Linked Server using the ODBC driver and the MSDASQL provider to query tables on a SQL Server instance. ODBC is designed for relational data stores. Microsoft Open Database Connectivity ( ODBC) is an application programming interface ( API) designed to access data from a different of database management systems ( DBMS).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |