Unanswered: ODBC timeout
This error occurs when I try to load data from a OpenVMS-box with OmniConnect, to a Sybase ASE 220.127.116.11 box, using a remote server that points to the OmniConnect-box.
20:22:13 17-06-2004 | I | [DataDirect][ODBC Sybase Wire | [DataDirect][ODBC Sybase Wire Protocol driver]Operation cancelled.
20:22:13 17-06-2004 | I | [DataDirect][ODBC Sybase Wire | [DataDirect][ODBC Sybase Wire Protocol driver]Timeout exceeded.
The criteria for loading the data is a date. Usually it is today minus 500 days, but that causes it to crash. When I set the date to use 1-12004 till today, it runs without problems.
I cannot find any option or parameter in neither the ODBC-datasource, nor the remote server, nor the ASE-server. The errormessage is also totally unknown to me.
All possible timeouts are configured more than sufficient.
It could be something it the program that controls it all, but that is not very likely. There are several other departments in my comapny that have no problems with it, although they may have less data to retrieve.
I'm not crazy, I'm an aeroplane!