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.

Connecting on SQL Server machine

4 posts in Windows NT Last posting was on 1998-03-25 09:49:28.0Z
Chris Steains Posted on 1998-03-24 09:54:06.0Z
Subject: Connecting on SQL Server machine
From: cls@intravel.com.au (Chris Steains)
Organization: Internet Travel
X-Newsreader: WinVN 0.99.9 (Beta 3) (x86 32bit)
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Message-ID: <c#0zIrwV9GA.129@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Tue, 24 Mar 1998 04:54:06 -0500
Lines: 13
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5101
Article PK: 1092462

We have just recently updated to System 11.0.3 from 11.0.2. I was checking the
connection setups and ran a SYBPING on the NT server that the Sybase system
runs on and the ping program reported that it used the NLNWLINK library (we run
IPX internally) to connect. I was always under the impression that Sybase used
the Named Pipes library to connect locally on the server. If this is not the case
then can I remove the Named Pipes listener entry on the server?

Chris Steains
cls@intravel.com.au


John McVicker Posted on 1998-03-24 11:52:53.0Z
From: "John McVicker" <mcvicker@sybase.com>
Organization: 192.175.209.26
References: <c#0zIrwV9GA.129@forums.powersoft.com>
X-Newsreader: AspNNTP (Advent 2000, Inc.)
Subject: Re: Connecting on SQL Server machine
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <eakngtxV9GA.569@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Tue, 24 Mar 1998 06:52:53 -0500
Lines: 38
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5099
Article PK: 1092463

Chris,
It uses locally the first entry in SQL.INI for the query line.
So, if IPX is the first line, it will use that. You can go with only
SPX for not only network but locally-connected clients. However,
if you do large data loads on the same host as the SQL Server, Named
Pipes is probably a faster protocol than SPX. Otherwise, for things
like ISQL, SPX should be just fine.

Run SQLEDIT or just edit %SYBASE%\INI\SQL.INI directly and set it up
with just the one listener. No reason to really take out named pipes,
but what you could do is rearrange the lines in SQL INI so that the
query lines have first the Named Pipes line and then the SPX line.
With two listeners, you can still process everything locally by one
"selected" protocol by arranging the lines in SQL.INI accordingly.

On Tue, 24 Mar 1998 04:54:06 -0500,
in sybase.public.sqlserver.nt

Chris Steains <cls@intravel.com.au> wrote:
>We have just recently updated to System 11.0.3 from 11.0.2. I was checking the
>connection setups and ran a SYBPING on the NT server that the Sybase system
>runs on and the ping program reported that it used the NLNWLINK library (we run
>IPX internally) to connect. I was always under the impression that Sybase used
>the Named Pipes library to connect locally on the server. If this is not the
case
>then can I remove the Named Pipes listener entry on the server?
>
>Chris Steains
>cls@intravel.com.au
>

John McVicker
Sybase Professional Services
Philadelphia, PA


Chris Steains Posted on 1998-03-25 09:49:28.0Z
Subject: Re: Connecting on SQL Server machine
From: cls@intravel.com.au (Chris Steains)
Organization: Internet Travel
X-Newsreader: WinVN 0.99.9 (Beta 3) (x86 32bit)
References: <c#0zIrwV9GA.129@forums.powersoft.com> <eakngtxV9GA.569@forums.powersoft.com>
MIME-Version: 1.0
Content-Type: Text/Plain; charset=US-ASCII
Message-ID: <gLdbNN9V9GA.650@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Wed, 25 Mar 1998 04:49:28 -0500
Lines: 43
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5097
Article PK: 1092461

In article <eakngtxV9GA.569@forums.powersoft.com>, mcvicker@sybase.com
says...

>
>Chris,
>It uses locally the first entry in SQL.INI for the query line.
>So, if IPX is the first line, it will use that. You can go with only
>SPX for not only network but locally-connected clients. However,
>if you do large data loads on the same host as the SQL Server, Named
>Pipes is probably a faster protocol than SPX. Otherwise, for things
>like ISQL, SPX should be just fine.
>
>Run SQLEDIT or just edit %SYBASE%\INI\SQL.INI directly and set it up
>with just the one listener. No reason to really take out named pipes,
>but what you could do is rearrange the lines in SQL INI so that the
>query lines have first the Named Pipes line and then the SPX line.
>With two listeners, you can still process everything locally by one
>"selected" protocol by arranging the lines in SQL.INI accordingly.
>
>On Tue, 24 Mar 1998 04:54:06 -0500,
> in sybase.public.sqlserver.nt
>Chris Steains <cls@intravel.com.au> wrote:
>>We have just recently updated to System 11.0.3 from 11.0.2. I was checking
the
>>connection setups and ran a SYBPING on the NT server that the Sybase
system
>>runs on and the ping program reported that it used the NLNWLINK library (we
run
>>IPX internally) to connect. I was always under the impression that Sybase
used
>>the Named Pipes library to connect locally on the server. If this is not the
>case
>>then can I remove the Named Pipes listener entry on the server?
>>
>>Chris Steains
>>cls@intravel.com.au
>>
>
>John McVicker
>Sybase Professional Services
>Philadelphia, PA

THANKS FOR THE INFO.

Chris Steains


Eoin Woods (Sybase UK) Posted on 1998-03-24 12:30:47.0Z
Message-ID: <3517A777.A5A693B3@sybase.com>
Date: Tue, 24 Mar 1998 12:30:47 +0000
From: "Eoin Woods (Sybase UK)" <eoin.woods@sybase.com>
X-Mailer: Mozilla 4.04 [en] (WinNT; I)
MIME-Version: 1.0
To: Chris Steains <cls@intravel.com.au>
Subject: Re: Connecting on SQL Server machine
References: <c#0zIrwV9GA.129@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 21
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5100
Article PK: 1092464


> We have just recently updated to System 11.0.3 from 11.0.2. I was
> checking the connection setups and ran a SYBPING on the NT server that
> the Sybase system runs on and the ping program reported that it used
> the NLNWLINK library (we run IPX internally) to connect. I was always
> under the impression that Sybase used the Named Pipes library to
> connect locally on the server. If this is not the case
> then can I remove the Named Pipes listener entry on the server?

Yes you can. ASE/SQL Server and the other Sybase servers need
connectivity to each other but they don't care what sort it is.

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