Kbase P101517: CorVu client crashing when running query on field with datatype date
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/6/2005 |
|
Status: Verified
FACT(s) (Environment):
Windows
Progress 9.1D
CorVu
SYMPTOM(s):
CorVu client crashing when running query on field with datatype date
CorVu client connecting via ABA server crashes with _sqlsrv2.exe - Application Error
2525 and 2526 messages appearing in lg
Disconnecting client <number> of dead server <number>. (2526)
Disconnecting dead server <number>. (2525)
Connecting via SQL-92 CorVu ABA server for Progress 9.1D
CAUSE:
This issue can occur when the database codepage and the operating system codepage are different.
The SQL-92 CorVu ABA server connects to the Progress database as a SQL-92 client, and is served using the Progress _sqlsrv2.exe. Unless otherwise specified, this client will use the operating system codepage. This can lead to discrepancies in how dates are handled for display.
The environment variable SQL_CLIENT_CHARSET can be used to specify the codepage the client uses to display data from the server if that codepage is to be different from the codepage the client operating system uses.
FIX:
The database codepage and the codepage used by the SQL-92 CorVu client connection should match.
1. Check the database codepage:
Data Administration > Utilities > Information... > Database code page
2. The environment variable SQL_CLIENT_CHARSET should be set to the same value as the database codepage. This can be done at the system level, e.g. on Windows 2000 Start > Settings > Control Panel > System > Advanced > Environment Variables.
3. If the variable is set at the system level, it will affect all SQL clients run from that machine, not just CorVu. An alternative is to set the variable under the Pre-Init tab in the CorVu ABA server, e.g.
SQL_CLIENT_CHARSET=ISO8859-1