Banyan VINES Clients

SQL Server supports Banyan VINES Sequenced Packet Protocol (SPP) as the IPC method across Banyan VINES IP network protocol. Banyan VINES support for Windows NT-based clients is available only on the Intel platform; it is not currently available on the MIPS or Alpha AXP platforms.

MS-DOS- and Windows-based clients require Banyan VINES client software version 4.11(5) or later. Windows NT version 3.5-based clients require Banyan VINES client software version 5.56(2) or later. Contact your Banyan support provider for information about the latest supported client software for each client platform.

A StreetTalk™ language PC-based service name has the form servicename@group@org, where servicename is the StreetTalk PC-based service name used by the SQL Server, group is the group, and org is the organization. (Note that the service name used by a SQL Server must first be created using the MSERVICE program included with your VINES software.)

For Windows- or Windows NT-based clients, you can use the SQL Client Configuration Utility, as described earlier in this chapter, to set up Banyan VINES connections.

If a client application gives a partial StreetTalk name (a name that doesn't include the group and organization) as the server name, the VINES SPP Net-Library will use standard VINES services to complete the rest of the StreetTalk name with your login defaults. If no PC-based service or nickname matching the server name is found within the user's own group and organization, the VINES SPP Net-Library looks for a special group named MSSQL within your organization. This allows network administrators to define a group of SQL Servers that are accessible with one-part names from all groups in the same organization.

You can override the default name MSSQL by setting a group@org variable on each client to a newgroup@org value. Both the group and organization are required.

For an MS-DOS-based client, this is an environment variable that must be set before the DBMSVINE.EXE Net-Library TSR is loaded. For example:

SET group@org=SQLServers@xyzcorp

For a Windows-based client, set group@org by adding a [DBMSVINE] section to your WIN.INI file. For example:

[DBMSVINE]
group@org=SQLServers@xyzcorp

For a Windows NT-based client, add a DBMSVINE key to the Windows NT Registry. Add the following key

\HKEY_LOCAL_MACHINE
    \SOFTWARE
        \Microsoft
            \ MSSQLServer
                \Client
                    \DBMSVINE

with a REG_SZ value group@org set to newgroup@org.

All of these examples change the default collection of SQL Servers to SQLServers@xyzcorp. Then, when any client application attempts to connect to a server named GIZMO, the VINES SPP Net-Library first looks for a PC-based service or nickname in your login group and then looks for one named GIZMO@SQLServers@xyzcorp.

The VINES SPP Net-Library files do not support the use of StreetTalk names that contain embedded spaces, and they use one VINES IP socket per server and one SPP connection per database connection.