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.

ODBC Configuration Adaptive Server Anywhere 9 accross separate subnet

3 posts in General Discussion Last posting was on 2006-12-07 17:01:16.0Z
modasras Posted on 2006-12-07 14:31:48.0Z
Sender: 7745.45783295.1804289383@sybase.com
From: modasras@colonie.org
Newsgroups: ianywhere.public.general
Subject: ODBC Configuration Adaptive Server Anywhere 9 accross separate subnet
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <457833e4.7774.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Dec 2006 07:31:48 -0700
X-Trace: forums-1-dub 1165505508 10.22.241.41 (7 Dec 2006 07:31:48 -0700)
X-Original-Trace: 7 Dec 2006 07:31:48 -0700, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5751
Article PK: 1750

I have a situation where my data base resides in subnet
172.1.1.x and my client resides on subnet 172.1.2.x.

I am having hard time configuring ODBC on client and testing
connection. connection failes. the network configuration
on odbc connection is set to tcpip checked and shared memory
checked. is there a configuration I can use that will work
for me.

Sunil Modasra
518-783-2857


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-12-07 14:38:44.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.8 (Windows/20061025)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Configuration Adaptive Server Anywhere 9 accross separate subnet
References: <457833e4.7774.1681692777@sybase.com>
In-Reply-To: <457833e4.7774.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <45783584$1@forums-1-dub>
Date: 7 Dec 2006 07:38:44 -0700
X-Trace: forums-1-dub 1165505924 10.25.98.170 (7 Dec 2006 07:38:44 -0700)
X-Original-Trace: 7 Dec 2006 07:38:44 -0700, keating-dm20.sybase.com
Lines: 44
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5752
Article PK: 1749

Use HOST in your connection i.e., the following connection string
fragment instructs the client to look on the machines kangaroo and
197.75.209.222 (port 2369) to find a database server:

LINKS=tcpip(IP=kangaroo,197.75.209.222:2369)

modasras@colonie.org wrote:
> I have a situation where my data base resides in subnet
> 172.1.1.x and my client resides on subnet 172.1.2.x.
>
> I am having hard time configuring ODBC on client and testing
> connection. connection failes. the network configuration
> on odbc connection is set to tcpip checked and shared memory
> checked. is there a configuration I can use that will work
> for me.
>
> Sunil Modasra
> 518-783-2857

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************

Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Breck Carter [Team iAnywhere] Posted on 2006-12-07 17:01:16.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: ODBC Configuration Adaptive Server Anywhere 9 accross separate subnet
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <24lgn2tc0atbbh8bkif7h5sp4d1ohvqqfj@4ax.com>
References: <457833e4.7774.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: 199.82.235.215
X-Original-NNTP-Posting-Host: 199.82.235.215
Date: 7 Dec 2006 10:01:16 -0700
X-Trace: forums-1-dub 1165514476 199.82.235.215 (7 Dec 2006 10:01:16 -0700)
X-Original-Trace: 7 Dec 2006 10:01:16 -0700, 199.82.235.215
Lines: 24
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5753
Article PK: 1751

Try adding HOST=172.1.1.x on the Network tab

On 7 Dec 2006 07:31:48 -0700, modasras@colonie.org wrote:

>I have a situation where my data base resides in subnet
>172.1.1.x and my client resides on subnet 172.1.2.x.
>
>I am having hard time configuring ODBC on client and testing
>connection. connection failes. the network configuration
>on odbc connection is set to tcpip checked and shared memory
>checked. is there a configuration I can use that will work
>for me.
>
>Sunil Modasra
>518-783-2857

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