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.

Sybase 11 on NT box with multiple Ethernet cards

5 posts in Windows NT Last posting was on 1997-11-26 18:23:51.0Z
Chris Steains Posted on 1997-11-21 03:28:55.0Z
Subject: Sybase 11 on NT box with multiple Ethernet cards
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: <uugyY2i98GA.182@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Date: Thu, 20 Nov 1997 22:28:55 -0500
Lines: 18
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5409
Article PK: 1081488

We are running Sybase system 11 on an NT4.0 box with multiple processor and 2
ethernet cards. Until now we have been using IPX to talk to the server,
however we have found through some WAN testing that TCP/IP performs better over
remote connections. My question is though, if we use TCP/IP, how can we
configure the Sybase server and the clients to be able to connect to the server
through either network card (the connections out of the server go straight into
a switching hub so there are not 2 distinct networks) so we don't have to
physically set differnet clients to talk to differnet IP addresses at the
server?

Chris Steains
Internet Travel Australia


Gary Kuever Posted on 1997-11-24 04:37:29.0Z
From: "Gary Kuever" <gkuever@ix.netcom.com>
References: <uugyY2i98GA.182@forums.powersoft.com>
Subject: Re: Sybase 11 on NT box with multiple Ethernet cards
Date: Sun, 23 Nov 1997 20:37:29 -0800
Lines: 6
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <az6I2mI#8GA.77@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5398
Article PK: 1081479

The way it works on UNIX is to edit your interfaces file and have the server
listen on both addresses. Not sure if NT can do this...
Gary


Ethan Smith Posted on 1997-11-26 18:23:51.0Z
From: nospam.ethans@pobox.com (Ethan Smith)
Subject: Re: Sybase 11 on NT box with multiple Ethernet cards
Date: Wed, 26 Nov 1997 18:23:51 GMT
Message-ID: <347c6906.9201180@forums.powersoft.com>
References: <uugyY2i98GA.182@forums.powersoft.com> <az6I2mI#8GA.77@forums.powersoft.com>
X-Newsreader: Forte Agent 1.5/32.451
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 11
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5389
Article PK: 1081469

Don't you still have to decide which address each client will connect
to?

On Sun, 23 Nov 1997 20:37:29 -0800, "Gary Kuever"

<gkuever@ix.netcom.com> wrote:

>The way it works on UNIX is to edit your interfaces file and have the server
>listen on both addresses. Not sure if NT can do this...
>Gary
>
>

---------------------------------------
To reply by e-mail, remove the "nospam"
prefix from the reply to address.


Adri Koppes Posted on 1997-11-26 09:05:54.0Z
From: adrik@salesmanager.nl (Adri Koppes)
Subject: Re: Sybase 11 on NT box with multiple Ethernet cards
Date: Wed, 26 Nov 1997 09:05:54 GMT
Organization: SalesManager Software B.V.
Reply-To: adrik@salesmanager.nl
Message-ID: <347be640.652157@forums.sybase.com>
References: <uugyY2i98GA.182@forums.powersoft.com> <az6I2mI#8GA.77@forums.powersoft.com>
X-Newsreader: Forte Agent 1.5/32.451
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 8
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5390
Article PK: 1081470


"Gary Kuever" <gkuever@ix.netcom.com> wrote:

>The way it works on UNIX is to edit your interfaces file and have the server
>listen on both addresses. Not sure if NT can do this...

I have done exactly that. Define both addresses and it works under NT
4.0 with Sybase 11.x

Adri.


Brad Brown Posted on 1997-11-21 07:11:32.0Z
Message-ID: <34753424.DCF868C8@sig.net>
Date: Fri, 21 Nov 1997 01:11:32 -0600
From: Brad Brown <foo@sig.net>
Reply-To: foo@sig.net
Organization: Verbose
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
To: Chris Steains <cls@intravel.com.au>
Subject: Re: Sybase 11 on NT box with multiple Ethernet cards
X-Priority: 3 (Normal)
References: <uugyY2i98GA.182@forums.powersoft.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 35
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5407
Article PK: 1081485

This will not work. Each adapter requires a unique TCP/IP address.

I suggest that you revert to IPX for LAN access
and assign a TCP/IP address to one of the adapters for WAN access.
Since
there is no way that a WAN can flood an ethernet, the remote users will
not
notice that they only get one of the network channels. The adapter can
bind to
both protocols in NT. Also, crank up the packet size for WAN access and

be sure to check this on your remote router as well. 2K should be
resonable.
That is one major difference inherent between IPX and
TCP/IP ( 512 bytes versus 1520 respectively by default).

thanks
bb

Chris Steains wrote:

> We are running Sybase system 11 on an NT4.0 box with multiple
> processor and 2
> ethernet cards. Until now we have been using IPX to talk to the
> server,
> however we have found through some WAN testing that TCP/IP performs
> better over
> remote connections. My question is though, if we use TCP/IP, how can
> we
> configure the Sybase server and the clients to be able to connect to
> the server
> through either network card (the connections out of the server go
> straight into
> a switching hub so there are not 2 distinct networks) so we don't have
> to
> physically set differnet clients to talk to differnet IP addresses at
> the
> server?
>
> Chris Steains
> Internet Travel Australia