Re: SqlAnywhere 9.0 Connection Failed ODBC via network TCP/IP

#1

The server name is not the IP and port.

It is the name of the of the engine. From the screen cap of Sybase
Central, the engine name is next to the SQL icon. For this engine, the
server name is AnyDb9_1.

Don't forget, you must use dbsrv9 (subject to licensing) to access over
a network.

KhooYh wrote:

Quote:

Hi,
I am currently developing a web using ASP.NET with the
requirement to connect to a SqlAnywhere 9.0 database server
via
network, not LOCAL pc.The problem is i have write a simple
test program in .NET, it work in Local pc but when i wish to
connect to the other database server locate in other pc in
the network, the connection could not establish.
I have attached the print screen that i am using the ODBC
connection, when i test connection that connect to local pc
database, it show connection success, but when i want to
connect to the network pc's database, it failed to connect,
any ideas ?

#2

Hi,
The server name i have tested using Ip, ip+port, and also
AnyDb9_1, but it also giving communication error.
may i know what you mean by dbsrv9? is that a server that
require licensing? and where to download? currently i am
using the SqlAnywhere 9.0 ver, and i download the developer
version to run it.

Quote:

The server name is not the IP and port.

It is the name of the of the engine. From the screen cap
of Sybase Central, the engine name is next to the SQL
icon. For this engine, the server name is AnyDb9_1.

Don't forget, you must use dbsrv9 (subject to licensing)
to access over a network.

KhooYh wrote:
Hi,
I am currently developing a web using ASP.NET with the
requirement to connect to a SqlAnywhere 9.0 database
server via
network, not LOCAL pc.The problem is i have write a
simple test program in .NET, it work in Local pc but
when i wish to connect to the other database server
locate in other pc in the network, the connection could
not establish. I have attached the print screen that i
am using the ODBC connection, when i test connection
that connect to local pc database, it show connection
success, but when i want to connect to the network pc's
database, it failed to connect, any ideas ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SqlAnywhere 9.0 Connection Failed ODBC via network TCP/IP

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: SqlAnywhere 9.0 Connection Failed ODBC via network TCP/IP - 09-12-2009 , 09:26 AM

Re: SqlAnywhere 9.0 Connection Failed ODBC via network TCP/IP - 09-13-2009 , 02:59 AM