Sybase Connection Terminates in Terminal Services Session
Hint Ref: 020703210008
Hint Date: 21/03/2007
Hint Details:
EFFECTED VERSION: 2.0.1.26
PROBLEM DETAILS: A User reported that when selecting the Sizecode option on the Maintenance Menu, whilst running Space Manager in a Terminal Services Session, the Sybase Database Connection instantly terminates.
This was traced to a database query, which when run resulted in the termination. Running the same query in SQL Tool did not always result in the termination.
SOLUTION: The issue was identified as being caused by the standard Sybase 8 ODBC settings that are installed by the wise installer.
A resolution is to remove the following parameters from the ODBC Advanced tab:
PROWS=50;PBUF=6000