Kbase P65610: Workaround to error 6175 when only one date field being inserted or updated
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/23/2009 |
|
Status: Verified
SYMPTOM(s):
Workaround to error 6175 when only one date field being inserted or updated
SYSTEM ERROR: Date/Time format error. (6175)
22008:[Microsoft] [ODBC SQL Server Driver] Invalid date format
FACT(s) (Environment):
The error occurs and the row does not get inserted or updated in the SQL Server Database.
Cannot upgrade to service pack 9.1D08
MS SQL DataServer
Progress 9.1x
Windows
CAUSE:
Bug # OE00096809
CAUSE:
This bug is fixed in service pack 9.1D08 and in OpenEdge Release 10.0A. The error is apparent when more then one SQL Server date fields mapped to timestamp(character) data type, and only one of the date field is being inserted or updated in the SQL Server Database.
FIX:
The workaround is to specify all the date fields in the code and assign unknown value(?) to the remaining date fields even if those do not require any data.