Explore BrainMass

Please answer and elaborate on the following

What are the various types of clients that can be used to connect to SQL Server 2000 and the network requirements necessary for successful communications between the client and server?

How do the Named Pipes and TCP/IP Sockets Named Libraries differ?

What are the benefits and drawbacks of using ODBC to configure your client applications?

Solution Preview

SQL Server 2000 supports several methods of communication between client applications and the server. When the application is on the same computer as an instance of SQL Server 2000, Windows Interprocess Communication (IPC) components, such as Local Named Pipes or Shared Memory, are used. When the application is on a separate client, a network IPC, such as TCP/IP or Named Pipes, is used to communicate with SQL Server.
SQL Server uses a dynamic link library, called a Net Library, to communicate with a particular network protocol. A matching pair of Net Libraries must be active on both client and server computers to support the desired network protocol. For example, to enable a client application to communicate with a specific instance of SQL Server across ...