SQLServer Tutorial

4 Client-Server Architecture Client Components Client Application A client application ends Transact-SQL statements and receives result sets. You develop an application by using a database API. Database API Database API (OLE DB, ODBC) uses a provider, driver, or DLL to pass Transact-SQL statements and receive result sets. This is an interface that an application uses to send requests to SQL Server and to process results that SQL Server returns. Client Net-Library This is a communication software component that packages the database requests and results for transmission by the appropriate network protocol. Server Components