SQL Anywhere is the default database used by Dispatch. In most cases, there will be no reason to make any changes to the default Data Source connection properties however Dispatch does provide complete control over all aspects of the connection properties.
Database driver
Database driver must be set to ASA.
ODBC Driver
The default option is Adaptive Server Anywhere 8.0. If you would like to use any version of SQL Anywhere, you will need to contact us for support.
Database
This property is used when connecting to a Personal server that has already been started. For example, you may have set up the personal server to start as a Windows Service.
The File name, Server and Host name properties must be empty when connecting to a Personal server that has already been started.
This property must be empty when connecting to a Network server or a file.
File name
The location and name of a local database file. If the file does not exist it will be created by the database engine. The Database, Server and Host name properties must be empty when connecting to a file.
This property must be empty when connecting to a Network server or a Personal server that has already been started.
Server
The name of a Network server.
This property must be empty when connecting to a Personal server or a file.
Host name
The IP address or name of the computer that is running the Network server.
This property only applies when connecting to a Network server. This property is ignored when connecting to a Personal server or a file.
ODBC Advanced
Generally this property is not used and should be left empty. We may ask you to set this property to assist in debugging.
User name
A unique identifier for a user. The default User name is dba. Leaving the User name property empty will cause Dispatch to display the Database Login dialog when Dispatch starts.
Password
The password associate with the User name. The password for the default User name is sql. Leaving the Password property empty will cause Dispatch to display the Database Login dialog when Dispatch starts.
The password must be supplied for the user to be allowed to connect to the database. As you type the password, each character type is shown as an asterisk (*).