Kbase P5681: GPF when reading MS Access table containing a GUID data type field
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
ODBC DataServer
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
Error 6227 occurs when reading a table
SYSTEM ERROR: _type_sqlc: Bad datatype -11 (6227)
Table is an Access table
MS Access 2000
GPF occurs after error
Table contains a GUID (Global Unique Identifier) data type field
The MS Access primary key is the last field of the table.
CAUSE:
Bug# 20020731-007
CAUSE:
The schema pull utilities did not skip any undefined data types. The GUID was not considered as a valid data type by the ODBC DataServer.
FIX:
There are 2 ways to solve the problem:
1- Migrate to OpenEdge 10.
The schema pull utilities will now skip any file that contain undefined data types.
or
2- Since GUID data type is not supported, do not pull GUID field into the Schema Holder.