I run an ASA Server v9 on a Windows Server 2003 system (hosted
server).

I want to connect from the clients to the server through the internet.

The clients use ODBC to connect and under TCP/IP settings
HOST=xxx.xxx.xxx.xxx;DOBROAD=NONE is set.

I can establish a connection with or without the DOBROAD parameter,
it's working but very slow. ( it takes minutes...)

I tested it at two different locations, the connection speed itself
can't be the problem. The DB is almost empty.

I think the server tries to connect to the client directly but can't
do it because of the firewalled connection.

Any suggestions?

Robz

The DOBROAD parameter tells the client software whether or not to use
UDP broadcasts to find the server. In your case, UDP broadcasts will not
find the server anyway, so turning them off can only save you time.

When you say "it's working but very slow", do you mean it takes a long
time to find the server and establish a connection, or once the
connection is established, executing statements and fetching results and
such is slow?

If the latter, you may find connection compression to be helpful.

Graeme Perrow
Senior Software Developer
gperrow _at_ ianywhere _dot_ com
Sybase iAnywhere Engineering

SQL Anywhere Developer Community
http://www.sybase.com/developer/libr...ere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs


robz wrote: