I used below connectionparm to connect remote ASA 8.0
database server. But it fails, pls advise.

SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='Driver=Adaptive Server
Anywhere 8.0;" &
+ "UID=dba;PWD=mapping;" &
+ "START=C:\Program Files\Sybase\SQL Anywhere
8\win32\dbeng8.exe;" &
+ "DATABASENAME=ers;" & + "ENG=ers_999;" &
+ "LINKS={TCPIP;DOBROAD=NONE;PORT=2638};" & +
"AUTOSTOP=NO;" &
+ "Charset=cp950;" &
+ "CommitOnDisconnect=NO;" & +
"',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NO PROMPT'"

You don't need to have START connection option since you are connecting
to an remote engine which should already be running.

The LINKS connection option should be written as:

LINKS=TCPIP{DOBROAD=NONE;HOST=<machine_name_or_ip> ;PORT=2638)

With DOBROAD=NONE, you must specify the HOST in your TCPIP protocol options.

ken wrote: