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 to network sybase server

3 posts in General Discussion (old) Last posting was on 2009-04-02 13:24:51.0Z
Luigi Galdi Posted on 2009-04-02 10:55:04.0Z
From: "Luigi Galdi" <lgaldi@serin.it>
Newsgroups: sybase.public.sqlanywhere
Subject: connect to network sybase server
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d49988@forums-1-dub>
Date: 2 Apr 2009 02:55:04 -0800
X-Trace: forums-1-dub 1238669704 10.22.241.152 (2 Apr 2009 02:55:04 -0800)
X-Original-Trace: 2 Apr 2009 02:55:04 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:272
Article PK: 866712

my pc have a ip 192.168.1.200
pc with ASA 8 (dbserv8) server have a ip 192.168.1.201
the database file ".db" is on pc 192.168.1.201
how i can build a odbc connection on my pc with a server sybase process who
run on 192.168.1.201

bye


Stephen Rice [Sybase] Posted on 2009-04-02 13:24:14.0Z
From: "Stephen Rice [Sybase]" <stevedotriceatsybasedotcom>
Newsgroups: sybase.public.sqlanywhere
References: <49d49988@forums-1-dub>
Subject: Re: connect to network sybase server
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d4bc7e$1@forums-1-dub>
Date: 2 Apr 2009 05:24:14 -0800
X-Trace: forums-1-dub 1238678654 10.22.241.152 (2 Apr 2009 05:24:14 -0800)
X-Original-Trace: 2 Apr 2009 05:24:14 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:273
Article PK: 866714

what command line so you use to start the server?

--
/steve
Stephen Rice, Sybase iAnywhere
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Docs : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"Luigi Galdi" <lgaldi@serin.it> wrote in message
news:49d49988@forums-1-dub...
> my pc have a ip 192.168.1.200
> pc with ASA 8 (dbserv8) server have a ip 192.168.1.201
> the database file ".db" is on pc 192.168.1.201
> how i can build a odbc connection on my pc with a server sybase process
> who
> run on 192.168.1.201
>
> bye
>
>


Jeff Albion [Sybase iAnywhere] Posted on 2009-04-02 13:24:51.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: connect to network sybase server
References: <49d49988@forums-1-dub>
In-Reply-To: <49d49988@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d4bca3$1@forums-1-dub>
Date: 2 Apr 2009 05:24:51 -0800
X-Trace: forums-1-dub 1238678691 10.22.241.152 (2 Apr 2009 05:24:51 -0800)
X-Original-Trace: 2 Apr 2009 05:24:51 -0800, vip152.sybase.com
Lines: 65
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:274
Article PK: 866715

Luigi,

1. Start a network server on 192.168.1.201:

dbsrv8 -n MyServer MyDatabase.db -n MyDatabase -x tcpip(PORT=2638)

2. Generate a connection string to connect to the database from
192.168.1.200:

dbisql -c
"UID=dba;PWD=sql;ENG=MyServer;DBN=MyDatabase;LINKS=tcpip(DOBROAD=NONE;HOST=192.168.1.201;PORT=2638)"


Alternatively, create a DSN:

1. Start -> Run -> odbcad32
2. Add...
3. Adaptive Server Anywhere 8.0
4.

[ODBC]
Data Source Name: MyDSN

[Login]
User ID: dba
Password: sql

[Database]
Server Name: MyServer
Database Name: MyDatabase

[Network]
[X] TCP/IP: HOST=192.168.1.201;PORT=2638;DOBROAD=NONE

Then connect:

dbisql -c "UID=dba;PWD=sql;DSN=MyDSN"


---

*Note: This will directly connect you to that IP and only that IP. If
you wanted to search your local subnet for the engine name, use:

1. dbsrv8 -n MyServer MyDatabase.db -n MyDatabase -x tcpip(PORT=2638)
2. dbisql -c "UID=dba;PWD=sql;ENG=MyServer;DBN=MyDatabase;"

Regards,

Luigi Galdi wrote:
> my pc have a ip 192.168.1.200
> pc with ASA 8 (dbserv8) server have a ip 192.168.1.201
> the database file ".db" is on pc 192.168.1.201
> how i can build a odbc connection on my pc with a server sybase process who
> run on 192.168.1.201

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/