Kbase P82741: MS-SQL sql_variant datatype causes error (6227)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2004 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Schema holder creation fails with error (6227).
SYSTEM ERROR: <proc-name>: Bad datatype <datatype>. (6227)
SYSTEM ERROR: _type_sqlc: Bad datatype 150. (6227)
MS-SQL Server DB uses SQL_VARIANT datatype in a field definition.
CAUSE:
Progress MS-SQL DataServer does not support the SQL_VARIANT datatype in a field definition.
FIX:
Redefine the field datatype from the MS-SQL Server DB to other than SQL_VARIANT.