Kbase P45972: MS SQL server dataserver crashes if MSS INT field is define
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/10/2003 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0A Beta
SYMPTOM(s):
Invalid character in numeric input (76)
Client attempting to access recid 665 not part of file 3072 (432)
Assert failure:rpos <= 0 (scfxky) Assert failure:file:: Y:/vobs_prgs/src/sfcys/sfky.c
line 313
When creating the dataserver schema for MSS after it does the initial pull from
all the tables in the MSS DB the dialog with the title "Transferring MSS
definition". At this point, error 76, 432 and assertion failure
The failuer occurs if the default value of a MSS INT field is defined as: '0' - string literals
Datadirect ODBC driver and Microsoft driver both fail
In 9.1D both drivers work, no errors
CAUSE:
Bug 20031002-033
CAUSE:
When checking a string to be a numeric, MS SQL server dataserver ignores spaces and allows numbers and a point.
FIX:
The bug has been fixed in OpenEdge 10.0A.
The fix changes all apostrophes to spaces so they are ignored