Hi,

I am trying to connect to a sybase ASA network server, but I only could do
that (remotely) by using an ODBC link. When I follow the example and set
DATA SOURCE=ASA 8.0 Sample, this "ASA 8.0 Sample" is an ODBC datasource.

Here is how I start the server:
"C:\program files\Sybase\SQL Anywhere 8\win32\dbsrv8.exe" -c 8m -n mydb
"C:\data\mydb.db", so the servername is 'mydb'.

And assuming the host name is 'THEHOST', where in the ADO connection string,
I specify the server IP or host name? Can anyone help me?

It only worked locally when I connected to the local server with DATA
SOURCE=mydb. In the remote client it only works if I set an ODBC datasource,
and use this datasource in the DATA SOURCE property from the ADA connection
string.

Thanks
Frank

You can use the ASA OLEDB Provider.
The Connection String is "ENG=MYDB;DBN=MYDB;UID=<username>;PWD=<password>"