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.

how to make a network connection to a SQL Anywhere 9 db

7 posts in General Discussion Last posting was on 2005-10-05 20:56:34.0Z
Marco Meoni Posted on 2005-09-23 15:46:45.0Z
Sender: 46ee.4334210e.1804289383@sybase.com
From: Marco Meoni
Newsgroups: ianywhere.public.general
Subject: how to make a network connection to a SQL Anywhere 9 db
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <43342316.478c.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 23 Sep 2005 08:45:26 -0700, 10.22.241.42
Lines: 20
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Sep 2005 08:45:27 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Sep 2005 08:46:45 -0700
X-Trace: forums-1-dub 1127490405 10.22.108.75 (23 Sep 2005 08:46:45 -0700)
X-Original-Trace: 23 Sep 2005 08:46:45 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4813
Article PK: 17429

Hello,
I'm running a pb9 app that uses a SQL Anywhere 9 db.
How can I setup the ODBC DSN (hostname, port etc) so that I
can access the db from 2 clients?
In other words, I'd like to access the database not just
from the local machine but from a 2nd network client too.

The ODBC settings allow me to enable tcp/ip connection and
specify host=myhost;port=myport for the remote client, BUT I
don't understand how to bind the db to a specified ip
address and port.

Summarizing, my scenario should be:
- machine A running the database and a pb9 application
connecting to it;
- machine B running an application that connects to db on
machine A

thank you in advance
Marco


Chris Keating (iAnywhere Solutions) Posted on 2005-09-23 15:59:49.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <43342316.478c.1681692777@sybase.com>
Subject: Re: how to make a network connection to a SQL Anywhere 9 db
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <43342627$1@forums-2-dub>
X-Original-Trace: 23 Sep 2005 08:58:31 -0700, keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Sep 2005 08:58:32 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Sep 2005 08:59:49 -0700
X-Trace: forums-1-dub 1127491189 10.22.108.75 (23 Sep 2005 08:59:49 -0700)
X-Original-Trace: 23 Sep 2005 08:59:49 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4814
Article PK: 17432

You have to host the database on dbsrvX. This is a network server engine and
is required to host a database that is to be shared. Please note that the
dbsrvX that is included with PB can only be used in development. Deployment
in production (i.e., access from an application) is subject to licensing.

Here is an example of an server start line:

dbsrv9 -n <server name> <other server options> <database file> -n <database
name>.

It is recommended that you use the -x option to limit the connectivity
protocols that the engine uses to only those required by the client. For
example, if you are running a purely TCPIP environment, non-TCPIP
comminications are not required.


If the database is in the same subnet, you simply have to provide the
following in the DSN
1) Server Name
2) Database Name
3) Connectivity protocol i.e., TCPIP

If you are not in the same subnet, you will need to add
HOST=<machine_name_or_ip> where <machine_name_or_ip> value is set to that of
machine A.

<Marco Meoni> wrote in message news:43342316.478c.1681692777@sybase.com...
> Hello,
> I'm running a pb9 app that uses a SQL Anywhere 9 db.
> How can I setup the ODBC DSN (hostname, port etc) so that I
> can access the db from 2 clients?
> In other words, I'd like to access the database not just
> from the local machine but from a 2nd network client too.
>
> The ODBC settings allow me to enable tcp/ip connection and
> specify host=myhost;port=myport for the remote client, BUT I
> don't understand how to bind the db to a specified ip
> address and port.
>
> Summarizing, my scenario should be:
> - machine A running the database and a pb9 application
> connecting to it;
> - machine B running an application that connects to db on
> machine A
>
> thank you in advance
> Marco