Kbase P37230: Getting 223 with MS SQL Server DataServer- convert the RAW field to CHAR before migrating
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
MS SQL DataServer
MS SQL 2000
SYMPTOM(s):
** Incompatible data types in expression or assignment. (223)
Getting error when compiling code against the MS SQL DataServer
Field in Progress is defined as data type RAW
Field in schema holder is defined as as a longvarchar
Field in SQL Server is defined as as a TEXT
Database was migrated using MS SQL Server Schema Migration tools
CAUSE:
RAW datatype is not currently supported in MS SQL Server DataServer.
FIX:
Change the RAW field definitions to CHAR before converting the database from Progress to MS SQL