Kbase P78061: Cannot load large text data into MS SQL server - Cut data smaller to work around
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/06/2005 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
Progress 9.1D
OpenEdge 10.0A
SYMPTOM(s):
Cannot load large text data into MS SQL server
An overflow of a character value. (6176)
[Microsoft][ODBC SQL Server Driver]String data, right truncation
The data being loaded is larger than 16K but smaller than 32K
The field is created in SQL server as text
The SQL server limit for text field is 2G
The field is created in schema holder as longvarchar
Loading the same data into a progress character field presents no problems
CAUSE:
Bug # 20040422-030
FIX:
Cut the data smaller than 16K and loads it into SQL server database or
Upgrade to 9.1E or 10.0B