Kbase P120436: Error 6194 when querying a table containing a Decimal data type
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/11/2006 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
Windows
SYMPTOM(s):
Error 6194 when querying a table containing a Decimal data type
SYSTEM ERROR: SQL number has an unexpected format. (6194)
Windows is non English platform
Using the MS SQL Server ODBC driver
The "Use regional settings when outputting currency, numbers, dates and times" check box in the Data Source Name (DSN) is enabled.
Starting the session with -numsep 46
The startup.pf file does not contain the -E parameter
CAUSE:
Since the "Use regional settings when outputting currency, numbers, dates and times" setting is enabled, the driver uses the default regional setting for the Windows login account of the user connecting through the data source.
For non English platform (such as Swedish, French, or German...), the decimal separator is the comma (","), whereas the DataServer expects a point (".").
FIX:
To fix the problem, uncheck the "Use regional settings when outputting currency, numbers, dates and times" check box in the Microsoft SQL Server DSN configuration.