Kbase P4705: Getting errors when running 4GL application SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
MS SQL DataServer
SYMPTOM(s):
Getting errors when running 4GL application SQL Server
Getting error S1002 Invalid descriptor index
SQL Server error S1002: [Microsoft] ODBC SQL Server driver, invalid descriptor index
Issue is not seen in Progress 9.1C
CAUSE:
Bug# 20020709-053
CAUSE:
Before Block Cursors were implemented in 9.1D, the MS SQL Server DataServer used late binding when allocating memory for query result sets.
Late binding of data is when a query is performed before a memory area has been targeted in the application for the result set. This requires data to be copied from the data source into the application after results have been produced.
Block cursors bind the memory for the result set before the query has been executed. This method cannot be used with text or image fields since they must be late bound.
The MSS DataServer had to be modified to use a mixed method for retrieving data that could handle both pre-bound and late bound methodologies when block cursors were turned on in order to accommodate records containing text and image fields.
This modification was done in V9.1D01.
FIX:
Disable block cursors;
-Dsrv PRGRS_BLOCK_CURS,0
or
Apply 9.1D01