Kbase P4380: GPF on SELECT statement when using SQL-92 engine
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/03/2003 |
|
Solution ID: P4380
FACT(s) (Environment):
Progress 9.1C
FACT(s) (Environment):
RedHat Linux 7.1
SYMPTOM(s):
A simple SELECT clause generates a GPF
SYSTEM ERROR: Memory violation. (49)
Query contains bind variables
Using SQL-92 ODBC Driver
Sample Clause :
SELECT <field_1>,<field_2> INTO :<var1>,:<var2> FROM <table> WHERE <field_1> = :<var3>
Another Sample Clause:
Select custnum,name from pub.customer where custnum = :MyBindVar
CAUSE:
The use of bind parameters in some statements makes the ODBC driver lose the reference of the value of the parameters passed to the SQLDescribeParam function.
The tracing from the ODBC Driver Manager shows that the last pointer has a value of zero.
myapp 4f0-740 ENTER SQLDescribeParam
HSTMT 01742A60
UWORD 1
SWORD * 0x0012E71C
SQLULEN * 0x0012E710
SWORD * 0x0012E704
SWORD * 0x00000000 <-Faulting pointer
FIX:
There exists some internal problems in the ODBC driver; this driver must be updated to its latest version. 9.1D driver included with Progress does not have this problem.
As Progress Software doesn't provide specific fixes for the ODBC driver the Client Networking product must be updated to 9.1D.