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.