Configuring .odbc.ini File

Configure the .odbc.ini file on the UNIX machine to include a pointer to the repository data server before setting up a repeated schedule task.

1. Use a text editor to open the etc/.odbc.ini file.
2. Add an entry similar to:
   [repository_data_server]
   uid=dba
   pwd=sql
   EngineName=demo
   CommLinks=tcpip(host=<hostname>;port=<portnumber>)
   AutoStop=no
   DatabaseName=demo
   where repository_data_server is the name of the SQL Anywhere data server.

   Note: Make sure that the entry does not include the "AutoPreCommit" connection parameter.
3. Save the file.
4. In the Scheduler, set up the repeated task, then run the job.