Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Which keys are updated when adding IP to SQL Server and when?

2 posts in Windows NT Last posting was on 1998-02-05 00:29:02.0Z
Bill Rickerson Posted on 1998-02-04 03:05:22.0Z
Message-ID: <34D7DAF1.68FD7DA4@buffnet.net>
Date: Tue, 03 Feb 1998 22:05:22 -0500
From: Bill Rickerson <rickersn@buffnet.net>
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
CC: Bill Rickerson <WRickerson@MandTBank.com>, Richard Widomski <RWidomski@MandTBank.com>
Subject: Which keys are updated when adding IP to SQL Server and when?
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 33
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5243
Article PK: 1081321

Can someone tell me when (or if) the registry is updated and which keys
are changed when I add a new network library to my SQL.INI / LIBCTL.CFG
files with SQLEDIT.EXE? Our network/OS support people would like to
know which keys we would be changing.
Say I am adding IP to my SQL Server (ver 11.0.1.1). It is a NT 4.0 /
SP3 box that already has TPC/IP bound to the network card. The SQL
Server has been using IPX/SPX up to this time. Next I 'add' the new
service (WNLWNSCK) and the network address (server_name, port_number,
URGENT). Then I 'update' the WNLWNSCK service. Then I exit SQLEDIT. I

know I have to recycle the SQL Server to be able to use the new service,

but when, if ever, is the registry updated in this process and which
keys are updated?

I would also like to know if there is a precedence among the services
listed in the SQL.INI? Specifically, if our Open Client modules have
both IP and IPX/SPX network services enabled. The Open Client modules
are stored on a file server which is accessed by many PB 5.03 clients,
some of which have IP and IPX/SPX stacks, some have only a IPX/SPX
stack. The question is, for the clients that have both protocols, how
can we be sure that they are using IP?

Thanks!
Bill Rickerson


Eoin Woods Posted on 1998-02-05 00:29:02.0Z
Message-ID: <34D907CE.EC99D9FB@sybase.com>
Date: Wed, 04 Feb 1998 16:29:02 -0800
From: Eoin Woods <eoin.woods@sybase.com>
Reply-To: eoin.woods@sybase.com
Organization: Sybase Inc.
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Bill Rickerson <rickersn@buffnet.net>
Subject: Re: Which keys are updated when adding IP to SQL Server and when?
References: <34D7DAF1.68FD7DA4@buffnet.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 23
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5240
Article PK: 1081318


Bill Rickerson wrote:
> Can someone tell me when (or if) the registry is updated and which keys
> are changed when I add a new network library to my SQL.INI / LIBCTL.CFG
> files with SQLEDIT.EXE? Our network/OS support people would like to
> know which keys we would be changing.

You don't update the registry when using SQLEDIT.EXE (now DSEDIT.EXE).
All the information is stored in SQL.INI.

> I would also like to know if there is a precedence among the services
> listed in the SQL.INI? Specifically, if our Open Client modules have
> both IP and IPX/SPX network services enabled.
I think OpenClient will just try them in the order they appear. If one
fails, it will attempt the next.

Eoin.
--
Eoin Woods, NT Development, ASE Engineering, Sybase Inc.
Sybase (UK), Crown Lane, Maidenhead, Berkshire, SL6 8QZ
Tel: +44-1628-597215 Fax: +44-1628-597000
Email: Eoin.Woods@sybase.com