SQL statements can be run via isql or dbaccess on the remote machine but when
attempting to connect to the database via SQL-Retriever you receive "File open Error #461"
. The finderr
command on UNIX does not really help either: "-461 File open error."
.
All file and database permissions were correctly set and SQL-Retriever appeared
to be installed correctly.
CAUSE:
Customer was using Infromix On-line 7 but had managed to install SQL-Retriever for Informix On-line 5. Any application that is compiled for Informix 7 is incompatiable with Informix 5. Running the SQL-Retriever demon from the command line with the '-v' option showed that was SQL-Retriever installed for the wrong version of Informix.
SOLUTION:
Re-install the SQL-Retriever 4 host module for Informix 7.
Bear in mind that there may be other causes for this error apart from the above.