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 across subnets

2 posts in General Discussion Last posting was on 2006-08-24 21:39:34.0Z
Jim Posted on 2006-08-24 18:27:25.0Z
Sender: 7e39.44edeeb4.1804289383@sybase.com
From: Jim
Newsgroups: ianywhere.public.general
Subject: Connecting across subnets
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44edef8d.7e40.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Aug 2006 11:27:25 -0700
X-Trace: forums-1-dub 1156444045 10.22.241.41 (24 Aug 2006 11:27:25 -0700)
X-Original-Trace: 24 Aug 2006 11:27:25 -0700, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5589
Article PK: 1618

Using SB central 3.0.0 I want to connect to databases that
are in another subnets in our company. New to setting up
the connections so anything from the start would help. I
want to centrally manage all the databases, make chages, see
tables, etc.


Greg Fenton Posted on 2006-08-24 21:39:34.0Z
From: Greg Fenton <greg.fenton@googles-mail-site>
User-Agent: Thunderbird 1.5.0.5 (Windows/20060719)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Connecting across subnets
References: <44edef8d.7e40.1681692777@sybase.com>
In-Reply-To: <44edef8d.7e40.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: wsp04839139wss.cr.net.cable.rogers.com
Message-ID: <44ee1a18$1@forums-2-dub>
X-Original-Trace: 24 Aug 2006 14:28:56 -0700, wsp04839139wss.cr.net.cable.rogers.com
Lines: 22
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Aug 2006 14:28:58 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Aug 2006 14:39:34 -0700
X-Trace: forums-1-dub 1156455574 10.22.108.75 (24 Aug 2006 14:39:34 -0700)
X-Original-Trace: 24 Aug 2006 14:39:34 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5592
Article PK: 1621


Jim wrote:
> Using SB central 3.0.0 I want to connect to databases that
> are in another subnets in our company. New to setting up
> the connections so anything from the start would help. I
> want to centrally manage all the databases, make chages, see
> tables, etc.

To connect in separate subnets, you likely need to specify the following
in your connection string:

eng=YOUR_SERVER;link=tcpip(host=YOUR_HOSTNAME;dobroadcast=no)

The "dobroadcast=no" argument tells the SQL Anywhere client library not
to do a UDP broadcast looking for YOUR_SERVER and instead to go straight
to the database server specified by the tcpip arguments.

BTW: what is SB central 3.0.0 ?

g.f
--
Greg Fenton
Some Random Dude