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.

SQL Any 5.5 TCP\IP connection help

3 posts in General Discussion Last posting was on 2003-10-30 14:23:29.0Z
justin Posted on 2003-10-29 23:33:38.0Z
From: "justin" <sharp_justin@hotmail.com>
Newsgroups: ianywhere.public.general
Subject: SQL Any 5.5 TCP\IP connection help
Lines: 8
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 21-253.sbcusd.k12.ca.us
X-Original-NNTP-Posting-Host: 21-253.sbcusd.k12.ca.us
Message-ID: <3fa05c62@forums-1-dub>
Date: 29 Oct 2003 16:33:38 -0700
X-Trace: forums-1-dub 1067474018 163.150.21.253 (29 Oct 2003 16:33:38 -0700)
X-Original-Trace: 29 Oct 2003 16:33:38 -0700, 21-253.sbcusd.k12.ca.us
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1957
Article PK: 4194

I know this is an old version. We are switching from ipx to ip for our
connectivity. Currently we are broadcasting ipx across the WAN (not good),
but as we switch to ip we no longer want to broadcast from the db to client,
but want a direct connection over the WAN. How can I do this? I am new to
the Sybase arena. So any help or resources you can provide would be greatly
appreciated.


Reg Domaratzki Posted on 2003-10-30 14:21:35.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <3fa05c62@forums-1-dub>
Subject: Re: SQL Any 5.5 TCP\IP connection help
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <3fa12c7f$1@forums-1-dub>
Date: 30 Oct 2003 07:21:35 -0700
X-Trace: forums-1-dub 1067527295 172.31.143.163 (30 Oct 2003 07:21:35 -0700)
X-Original-Trace: 30 Oct 2003 07:21:35 -0700, rdomarat-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1968
Article PK: 4201

Assuming that on Machine A (let's say it's IP address is 10.1.1.1, subnet
mask 255.0.0.0) you start the database server with the following :

dbsrv50 -n MyServ -x tcpip c:\data\MyDB.db

Now, on machine B (let's say it's IP address is 11.1.1.1, subnet mask
255.0.0.0, note the DIFFERENT network), you should be able to start dbclient
with :

dbclient -x tcpip{DoBroadcast=no;Host=10.1.1.1} MyServ

This should find the server without doing a broadcast, whether the server
resides in the same network, or a different network.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"justin" <sharp_justin@hotmail.com> wrote in message
news:3fa05c62@forums-1-dub...
> I know this is an old version. We are switching from ipx to ip for our
> connectivity. Currently we are broadcasting ipx across the WAN (not good),
> but as we switch to ip we no longer want to broadcast from the db to
client,
> but want a direct connection over the WAN. How can I do this? I am new to
> the Sybase arena. So any help or resources you can provide would be
greatly
> appreciated.
>
>


Reg Domaratzki Posted on 2003-10-30 14:23:29.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <3fa05c62@forums-1-dub>
Subject: Re: SQL Any 5.5 TCP\IP connection help
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <3fa12cf1$1@forums-1-dub>
Date: 30 Oct 2003 07:23:29 -0700
X-Trace: forums-1-dub 1067527409 172.31.143.163 (30 Oct 2003 07:23:29 -0700)
X-Original-Trace: 30 Oct 2003 07:23:29 -0700, rdomarat-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1969
Article PK: 4204

PS: I've assume v5.5.05 latest EBF (build 2778) since you didn't post an
exact version and that's what I had on my machine. I', not positive that
the DoBroadcast option exists in some earlier versions of v5.5, but you can
certainly always use the HOST parameter to locate the server.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"justin" <sharp_justin@hotmail.com> wrote in message
news:3fa05c62@forums-1-dub...
> I know this is an old version. We are switching from ipx to ip for our
> connectivity. Currently we are broadcasting ipx across the WAN (not good),
> but as we switch to ip we no longer want to broadcast from the db to
client,
> but want a direct connection over the WAN. How can I do this? I am new to
> the Sybase arena. So any help or resources you can provide would be
greatly
> appreciated.
>
>