Knowledge Base Article
KB10653 - I tried to connect to Oracle using the Borland DBX driver but it throws an exception. What's wrong?
A: Probably the exception relates to the dot versus coma issue in the format of numbers. This is a known problem with the Oracle driver, i.e., that it only recognizes the dot " . " as the decimal separator. Some localizations, such as in Germany, require a coma " , ".
Solution:
1) open the registry with regedit
2) locate the key HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMExxx
3) change the subkey NLS_LANG from what ever you have to
AMERICAN_AMERICA.WE8MSWIN1252
Created: 2005-10-28, Modified: 2005-10-28
|