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.

Connect by IP address

4 posts in General Discussion Last posting was on 2006-03-29 16:26:44.0Z
E.A Posted on 2006-03-29 12:22:59.0Z
From: "E.A" <ea@hotmail.com>
Newsgroups: ianywhere.public.general
Subject: Connect by IP address
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: asakim.bb.netvision.net.il
Message-ID: <442a6bff$1@forums-2-dub>
X-Original-Trace: 29 Mar 2006 03:14:07 -0800, asakim.bb.netvision.net.il
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Mar 2006 03:14:11 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Mar 2006 04:22:59 -0800
X-Trace: forums-1-dub 1143634979 10.22.108.75 (29 Mar 2006 04:22:59 -0800)
X-Original-Trace: 29 Mar 2006 04:22:59 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5245
Article PK: 1303

Hello,

I want to develope in Web, and I don't success to connect to DB Sybase. (if
I work with DB MS SQLSERVER it's connect):

1. In the Client I write IP address of Server and try to connect it.

2. I run:

dbsrv.exe -x tcpip(host=192.168.1.1;port=2638)

(192.168.1.1- IP Address of Server)


3. If I change IP Adrress, it don't connect by IP Adrress but it connect
because the name's Engine.

Can somebady help me?

Thanks


Breck Carter [TeamSybase] Posted on 2006-03-29 14:11:13.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Connect by IP address
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <3b0l22p0iaseqn40l8deg5amdide9hqkqs@4ax.com>
References: <442a6bff$1@forums-2-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
X-Original-Trace: 29 Mar 2006 05:02:21 -0800, bcarter.sentex.ca
Lines: 85
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Mar 2006 05:02:23 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Mar 2006 06:11:13 -0800
X-Trace: forums-1-dub 1143641473 10.22.108.75 (29 Mar 2006 06:11:13 -0800)
X-Original-Trace: 29 Mar 2006 06:11:13 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5246
Article PK: 1302

There's some confusion here, so let's start from scratch. Here is a
sample command file for starting a network server (which is separate
from the client):

=====
REM -c ... initial RAM cache size
REM -cw enable Address Windowing Extensions for large fixed cache
sizes
REM -n ... server name
REM -o ... where to put server console display text file
REM -os 1M when to rename and restart server console display text
file
REM -gn ... maximum number of concurrent active tasks
REM -r read only
REM -ti 0 disable idle client timeout
REM -x tcpip speed startup by enabling only client protocols tcpip and
shmem
REM ddd.db first database to start
REM -n ... database name

"%ASANY9%\win32\dbsrv9.exe" -x tcpip ddd.db
=====

Note that "database name" defaults to ddd, and then the "server name"
defaults to ddd as well. You typically do NOT specify a HOST parameter
because the server's own IP address is the address of the machine it's
running on, and it knows that :)

Note also that 2638 is the default port.

When connecting from a client, you often do not need to know anything
except the server and engine name via ENG=ddd;DBN=ddd;, but here is a
sample that specifies host and forces it to look only there via
DOBROAD=NONE:

=====
"%ASANY9%\win32\dbisql.exe" -c
"ENG=ddd;DBN=ddd;UID=dba;PWD=sql;LINKS=TCPIP(HOST=123.123.123.123;DOBROAD=NONE)"
=====

You can use domain names or localhost too. Firewalls may require you
do specify a port; let us know if that's what you need.

SQL Anywhere offers a billion parameters affecting connections, since
the product is used in so many different environments. This sometimes
makes it confusing. On the other hand, database like SQL Server and
Oracle are often used in one kind of environment: one giant database
in one place that everyone connects to, so once you figure out how to
connect, you don't have to fiddle any more.

If you have ANY other questions, just ask here!

Breck

On 29 Mar 2006 04:22:59 -0800, "E.A" <ea@hotmail.com> wrote:

>Hello,
>
>I want to develope in Web, and I don't success to connect to DB Sybase. (if
>I work with DB MS SQLSERVER it's connect):
>
> 1. In the Client I write IP address of Server and try to connect it.
>
> 2. I run:
>
> dbsrv.exe -x tcpip(host=192.168.1.1;port=2638)
>
> (192.168.1.1- IP Address of Server)
>
>
> 3. If I change IP Adrress, it don't connect by IP Adrress but it connect
>because the name's Engine.
>
>Can somebady help me?
>
>Thanks
>
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


E.A Posted on 2006-03-29 16:00:54.0Z
From: "E.A" <ea@hotmail.com>
Newsgroups: ianywhere.public.general
References: <442a6bff$1@forums-2-dub> <3b0l22p0iaseqn40l8deg5amdide9hqkqs@4ax.com>
Subject: Re: Connect by IP address
Lines: 116
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: asakim.bb.netvision.net.il
Message-ID: <442a9f13$1@forums-2-dub>
X-Original-Trace: 29 Mar 2006 06:52:03 -0800, asakim.bb.netvision.net.il
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Mar 2006 06:52:04 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Mar 2006 08:00:54 -0800
X-Trace: forums-1-dub 1143648054 10.22.108.75 (29 Mar 2006 08:00:54 -0800)
X-Original-Trace: 29 Mar 2006 08:00:54 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5247
Article PK: 1304

Thank you for your answer.





Unfortunately, I did not succeed. I'll explain the problem again:



I got client computer, and I want to connect it to another computer through
the internet. On that computer there's Sybase DB.

I have the IP of that distance computer that it's really the Internet IP
address.

I want to connect to that computer by giving the address of the Internet IP,
and through that to connect to the Sybase DB.





"Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com> ???
??????:3b0l22p0iaseqn40l8deg5amdide9hqkqs@4ax.com...

> There's some confusion here, so let's start from scratch. Here is a
> sample command file for starting a network server (which is separate
> from the client):
>
> =====
> REM -c ... initial RAM cache size
> REM -cw enable Address Windowing Extensions for large fixed cache
> sizes
> REM -n ... server name
> REM -o ... where to put server console display text file
> REM -os 1M when to rename and restart server console display text
> file
> REM -gn ... maximum number of concurrent active tasks
> REM -r read only
> REM -ti 0 disable idle client timeout
> REM -x tcpip speed startup by enabling only client protocols tcpip and
> shmem
> REM ddd.db first database to start
> REM -n ... database name
>
> "%ASANY9%\win32\dbsrv9.exe" -x tcpip ddd.db
> =====
>
> Note that "database name" defaults to ddd, and then the "server name"
> defaults to ddd as well. You typically do NOT specify a HOST parameter
> because the server's own IP address is the address of the machine it's
> running on, and it knows that :)
>
> Note also that 2638 is the default port.
>
> When connecting from a client, you often do not need to know anything
> except the server and engine name via ENG=ddd;DBN=ddd;, but here is a
> sample that specifies host and forces it to look only there via
> DOBROAD=NONE:
>
> =====
> "%ASANY9%\win32\dbisql.exe" -c
> "ENG=ddd;DBN=ddd;UID=dba;PWD=sql;LINKS=TCPIP(HOST=123.123.123.123;DOBROAD=NONE)"
> =====
>
> You can use domain names or localhost too. Firewalls may require you
> do specify a port; let us know if that's what you need.
>
> SQL Anywhere offers a billion parameters affecting connections, since
> the product is used in so many different environments. This sometimes
> makes it confusing. On the other hand, database like SQL Server and
> Oracle are often used in one kind of environment: one giant database
> in one place that everyone connects to, so once you figure out how to
> connect, you don't have to fiddle any more.
>
> If you have ANY other questions, just ask here!
>
> Breck
>
> On 29 Mar 2006 04:22:59 -0800, "E.A" <ea@hotmail.com> wrote:
>
>>Hello,
>>
>>I want to develope in Web, and I don't success to connect to DB Sybase.
>>(if
>>I work with DB MS SQLSERVER it's connect):
>>
>> 1. In the Client I write IP address of Server and try to connect it.
>>
>> 2. I run:
>>
>> dbsrv.exe -x tcpip(host=192.168.1.1;port=2638)
>>
>> (192.168.1.1- IP Address of Server)
>>
>>
>> 3. If I change IP Adrress, it don't connect by IP Adrress but it connect
>>because the name's Engine.
>>
>>Can somebady help me?
>>
>>Thanks
>>
>>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com


Greg Fenton Posted on 2006-03-29 16:26:44.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Connect by IP address
References: <442a6bff$1@forums-2-dub> <3b0l22p0iaseqn40l8deg5amdide9hqkqs@4ax.com> <442a9f13$1@forums-2-dub>
In-Reply-To: <442a9f13$1@forums-2-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <442ab544$1@forums-1-dub>
Date: 29 Mar 2006 08:26:44 -0800
X-Trace: forums-1-dub 1143649604 69.193.72.112 (29 Mar 2006 08:26:44 -0800)
X-Original-Trace: 29 Mar 2006 08:26:44 -0800, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 43
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5248
Article PK: 1305


E.A wrote:
> I got client computer, and I want to connect it to another computer through
> the internet. On that computer there's Sybase DB.
>
> I have the IP of that distance computer that it's really the Internet IP
> address.

Then what you need to do is to get your client connection string correct.

Since you are going through the Internet, then the client's default UDP
broadcasting likely will fail. So I recommend using the following test
command:

dbping -d -c
"uid=<U>;pwd=<P>;eng=<S>;dbn=<D>;links=tcpip(host=<I>;dobroadcast=none);LOG=c:\asa_connect.txt"

where:

<U> is your username (e.g. "dba")
<P> is the user's password
<S> is the name of the server
<D> is the database name
<I> is the hostname or IP address of the machine where the server is
running.

If this does not work, then reply posting two pieces of information:

1. the *exact* command line used to start the server
2. the contents of c:\asa_connect.txt (contains debugging information
from the connection attempt)

BTW: for future reference, ASA questions are be better posted in the
other newsgroup you had posted to: sybase.public.sqlanywhere.general.
But let's finish this thread here.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/