Sybase Adaptive Server Anywhere Configuration

1. Copy the JDBC Driver files to your application server's path or the cdaily-5.0.0/WEB-INF/lib directory.
2. Create the database using the dbinit command.
   
   dbinit databasename
   
3. If necessary modify the startup script for the SQL Anywhere engine to include the new database.
4. Load the database schema.
   
   dbisql -q -c \ “dbn=databasename;dbf=databasename;uid=userid;pwd=password” \
InstallationDirectory\cdaily-5.0.0/WEB-INF\sql\SYB_SQLA\calschema.sql
5. Edit the configuration.properties file, putting in the configuration entries for your database.

DBObjectClass=com.MHSoftware.db.support.SybaseSQLADB
JDBCConnectString=jdbc\:sybase\:Tds\:machine-name\:2638?ServiceName\=DBN
JDBCDriver=com.sybase.jdbc2.jdbc.SybDriver
JDBCPassword=calendar
JDBCUserID=calendar

Note The \ character shows a line continuation. Do not type the character.

For additional information on the connection parameter (-c xxx), refer to the Sybase SQL Anywhere documentation.