Problem:

Connecting to AcuXDBC server resulted in one of the following errors:

SQLState: 28000 EXECFAIL: Exec 'acuxdbc04' failed on host 'my_server' (errno: 2)

Connection failed:

SQL State: 28000

[TOD] [ODBC Driver] EXECFAIL: Exec 'acuxdbc04' failed on host '192.100.1.1' (errno: 0)

Resolution:

The typical reasons for this problem are related to permissions, e.g. which user started AcuXDBC Server and/or what the permissions are for the files AcuXDBC Server needs.

This may be resolved by adding "export PATH=$PATH:/opt/acucorp/nnn/bin" (where 'nnn' is replaced by the correct directory, e.g.: 740 or 800) at the beginning of the acuxdbcs.sh script, that way regardless of which user starts AcuXDBC Server the correct environment settings will be in place.