Interoperability with Other Systems through HTTP Endpoints

Each Relational Database Management System (RDBMS) exposes an Application Programming Interface (API) that developers can use to interoperate with the database.

OLE DB, ODBC, DB-LIB, JDBC, and SQLNCLI are all examples of data access providers. A data access provider encapsulates the complex logic implemented by the API for an RDBMS. A data access provider also exposes a common interface that allows application developers to write data access logic once and be able to interoperate with multiple RDBMSs. The fact is that, to be able to talk to a specific RDBMS, application development platforms require support from a data access provider.

With HTTP Endpoints, SQL Server 2005 provides an ...

Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step 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.