Kbase P119674: Error 6227 reading SQL server table with sysname columns
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/19/2006 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
SYMPTOM(s):
Error 6227 reading SQL server table
SYSTEM ERROR: <proc-name>: Bad datatype <datatype>. (6227)
SYSTEM ERROR: <proc-name>: Bad datatype -9. (6227)
There are SQL server sysname data type columns in the table
CAUSE:
These sysname columns are not supported by SQL server data server
FIX:
Write stored procedure to query the table. You will need to use covert function to convert these sysname columns into text.