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.

tcpip connectivity

2 posts in General Discussion Last posting was on 2007-03-13 14:56:40.0Z
shif Posted on 2007-03-13 13:49:33.0Z
Sender: 7874.45f6a710.1804289383@sybase.com
From: shif
Newsgroups: ianywhere.public.general
Subject: tcpip connectivity
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <45f6abed.792c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Mar 2007 05:49:33 -0800
X-Trace: forums-1-dub 1173793773 10.22.241.41 (13 Mar 2007 05:49:33 -0800)
X-Original-Trace: 13 Mar 2007 05:49:33 -0800, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5874
Article PK: 1858

Hi
I am using sqlanywhere db and we are having 5 locations
connected with router.from my central location i can be able
to connect each location databases.iam using 5 dsn for 5
locations.i am giving the tcpip parameter
port=192.122.122.5:2639 and ip is different for each
locations.now i am facing a problem that ,i am having the
service name and database name same in all locations.
So after connecting to one location,when i try for 2nd
location
with 2nd Dsn it is conencting to the same Ist db only.do i
want to make any changes in the tcpip parameter for
connecting to specified location.please help
thanks


Breck Carter [Team iAnywhere] Posted on 2007-03-13 14:56:40.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: tcpip connectivity
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <leedv2102t8k26tvrra9nlg6p3gg6pm3ft@4ax.com>
References: <45f6abed.792c.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 13 Mar 2007 06:56:40 -0800
X-Trace: forums-1-dub 1173797800 64.7.134.118 (13 Mar 2007 06:56:40 -0800)
X-Original-Trace: 13 Mar 2007 06:56:40 -0800, bcarter.sentex.ca
Lines: 57
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5875
Article PK: 1857

Short answer: Add DOBROAD=NONE to the TCPIP parameter list when
connecting.

Long answer: if your connection string looks like this:

"ENG=ddd;DBN=ddd;UID=dba;PWD=sql;LINKS=TCPIP(HOST=192.122.122.5:2639"

...try this instead:

"ENG=ddd;DBN=ddd;UID=dba;PWD=sql;LINKS=TCPIP(HOST=192.122.122.5:2639;DOBROAD=NONE)"

Here is the Help description for V9:

=====
Specifying DoBroadcast=NONE causes no UDP or IPX broadcasts to be used
and the server address cache (asasrv.ini) is ignored. A TCP/IP or SPX
connection is made directly with the HOST/PORT specified, and the
server name is verified. With TCP/IP, you can choose not to verify the
server name by setting the VerifyServerName (VERIFY) protocol option
to NO. The HOST (IP) protocol option is a required parameter, while
the ServerPort (PORT) protocol option is optional.
=====

IMO SQL Anywhere sometimes TRIES TOO HARD to find a server, and the
rules for finding a server are EXTREMELY COMPLEX... with the bottom
line that it sometimes finds the WRONG SERVER. Sure, it's finding the
"right server" according to the rules, but it's a little bit like
NASCAR: nobody really understands the rules.

Anyway, DOBROAD=NONE is often very effective as a painkiller.

Breck

On 13 Mar 2007 05:49:33 -0800, shif wrote:

>Hi
>I am using sqlanywhere db and we are having 5 locations
>connected with router.from my central location i can be able
>to connect each location databases.iam using 5 dsn for 5
>locations.i am giving the tcpip parameter
>port=192.122.122.5:2639 and ip is different for each
>locations.now i am facing a problem that ,i am having the
>service name and database name same in all locations.
>So after connecting to one location,when i try for 2nd
>location
>with 2nd Dsn it is conencting to the same Ist db only.do i
>want to make any changes in the tcpip parameter for
>connecting to specified location.please help
>thanks

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com