The sqlcmd command prompt utility and SQL Server Management Studio, are examples of OLE DB applications. The OLE DB provider mediates between SQL Server and client applications that consume SQL Server data as OLE DB rowsets. These applications use the SQL Server Native Client OLE DB provider to connect to an instance of SQL Server. SQL Server clients can include applications of various types, such as: The default client configurations suffice in most situations. The client/server architecture of SQL Server allows it to seamlessly manage multiple clients and servers on a network. ![]() Typically, however, a client connects to one or more remote servers over a network. The computer that hosts this application is referred to as the client computer.Īt the simplest level, a SQL Server client can reside on the same machine as an instance of SQL Server. ![]() A "client" is a front-end application that uses the services provided by a server such as the SQL Server Database Engine. ![]() ![]() Applies to: SQL Server (all supported versions)Ĭlient software enables client computers to connect to an instance of Microsoft SQL Server on a network.
0 Comments
Leave a Reply. |