Purchase Solution

Please answer and elaborate on the following

Not what you're looking for?

Ask Custom Question

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?

Purchase this Solution

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 ...

Purchase this Solution

Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Javscript Basics

Quiz on basics of javascript programming language.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C# variables and classes

This quiz contains questions about C# classes and variables.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.