I need to setup ASA9 database in client/server.

In HOST (192.168.1.2) I started the server with Shortcut with the command
line: "C:\Program Files\Sybase\SQL Anywhere 9\win32\dbsrv9.exe" -c 8m -x
tcpip -n database1 "C:\bd\fact.db"

In Client PC, my application (PowerBuilder) connect with database by OBCD
(DSN=database_odbc)

The ODBC setup is:
Database tab:
Server name: ???
Start line: "C:\Program Files\Sybase\SQL Anywhere
9\win32\dbsrv9.exe" -x tcpip(HOST=192.168.1.2;PORT=2638)
Database name: ???
Database file: ???

I want to use the database with TPCIP connection, without Shared the
"C:\bd\fact.db" on the HOST (No Database file)

Please, help me.

Thanks.

If the database is already running on a network server, you should not
provide a startline in the ODBC DSN. For this case (based on your
shortcut used to start the database engine), you can provide

server name = FACT
Database Name = FACT

and select TCP/IP on the Network tab.



Miguel wrote:

Actually:
server name = database1 (since -n is before the .db file)
and database name = fact (no -n parameter after the database, so defaults to
base file name)

Since your client & server machines are different, don't include Start line
or database file.
tick Network > TCPIP, and add "HOST=192.168.1.2" as the TCPIP protocol
option (without the quotes)

--

Ian McHardy (Sybase iAnywhere)

Please reply only to the newsgroup.

SQL Anywhere 11 FAQ - http://www.sybase.com/detail?id=1064084
SQL Anywhere Developer Community -
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center - http://www.sybase.com/sqlanyblogs
"Chris Keating [Sybase iAnywhere]" <no_spam_me_keating (AT) sybase (DOT) com> wrote in
message news:4a82bdc0$1 (AT) forums-3-dub (DOT) sybase.com...