How to use a driver with Adaptive Server Anywhere ?

[VISOCO Support]

There are few significant moments:

1. The server must be started with TCP/IP support.
ASA enables TCP/IP communication protocol by default using port 2638.
(See -x command line option)

2. You can specify a database name on the command line.
dbsrv8 asademo -n "demo"
Since a database server can load several databases, the database
name is used to distinguish the different databases. If you don't
specify a database name the database receives the name of the
database file without a path and extension.
(See -n command line option)

3. The database must be created with ASE COMPATIBLE option.
Then the SYS.SYSCOLUMNS and SYS.SYSINDEXES views will not be created.
These views conflict with the Sybase Adaptive Server Enterprise
views dbo.syscolumns and dbo.sysindexes and cause errors in ISQLMetadata.
(See CREATE DATABASE statement)

4. The interfaces file at the client machine must contain an entry
specifying the machine name on which the database server is running,
and the TCP/IP port it uses. You can do it with the DSEdit utility.
The server name entry MUST be the same as the database name provided
on the Adaptive Server Anywhere command line.

5. Database parameter of SQLConnection Params property must be in format
<SERVER_NAME> instead of ASE's <SERVER_NAME>:<DATABASE_NAME>.
<SERVER_NAME> is a server entry name specified in the interfaces file as
described above.


For more information see "ASA Database Administration Guide"
http://manuals.sybase.com/onlinebooks/group-sas/awg0800e/dbdaen8
Part 1: Starting and Connecting to Your Database
Chapter 4: Adaptive Server Anywhere as an Open Server