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.

server port number

2 posts in Windows NT Last posting was on 2000-01-05 16:41:14.0Z
Yasha Brener Posted on 2000-01-05 16:34:14.0Z
From: "Yasha Brener" <yasha@net-reality.com>
Subject: server port number
Date: Wed, 5 Jan 2000 18:34:14 +0200
Lines: 14
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <FDpt6s5V$GA.298@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 192.116.42.65
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2739
Article PK: 1090129

I use NT 4.0 and Sybase 11.03.3.
In master db there is a syslisteners table from which it is possible
to know port number and other tcp connections values. I have seen this
in UNIX version. But on NT version I see that this table is empty ?

May be there is another way to know with SQL QUERY in what
port number server is listening ?

Any suggestion appreciated
Yasha.


Jason Froebe Posted on 2000-01-05 16:41:14.0Z
Message-ID: <3873742A.172399A6@sybase.com>
Date: Wed, 05 Jan 2000 10:41:14 -0600
From: Jason Froebe <jfroebe@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Yasha Brener <yasha@net-reality.com>
Subject: Re: server port number
References: <FDpt6s5V$GA.298@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------4F528A6F225556A817289581"
Newsgroups: sybase.public.sqlserver.nt
Lines: 33
NNTP-Posting-Host: jfroebe-desktop.sybase.com 157.133.46.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2738
Article PK: 1090124


Yasha Brener wrote:

> I use NT 4.0 and Sybase 11.03.3.
> In master db there is a syslisteners table from which it is possible
> to know port number and other tcp connections values. I have seen this
> in UNIX version. But on NT version I see that this table is empty ?
>
> May be there is another way to know with SQL QUERY in what
> port number server is listening ?
>
> Any suggestion appreciated
> Yasha.

Hi Yasha,

It's not a table but a separate file.

Unix: interfaces
Win32: sql.ini

These are in your $SYBASE or %SYBASE% directory.

Jason


Download VCard jfroebe.vcf