Base de Conocimientos Técnicos

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