BUG: International Settings Ignored

Q126287

The information in this article applies to:

SYMPTOMS

When installing the SQL Server client software on a Windows NT Workstation or Server, the DB-Library (DB-Lib) clients use the international settings to display data, by default.

If the default Use International Settings has been disabled and the SQL Client Configuration Utility is later used to enable this setting, the SQL Server DB-Lib client ignores this setting.


CAUSE

Use International Settings is controlled by a registry key in the HKEY_LOCALMACHINE section called 


   SOFTWARE\Microsoft\SQLServer\Client\DB-Lib\UseIntlSettings
By default this key is set to the value "ON". When this option is switched on by the SQL Client Configuration Utility, this key is instead set to the value "on". The function that reads this key is case sensitive and expects the value to be in upper case.


WORKAROUND

WARNING: Using Registry Editor incorrectly can cause serious, system-wide problems that may require you to reinstall Windows NT to correct them. Microsoft cannot guarantee that any problems resulting from the use of Registry Editor can be solved. Use this tool at your own risk.

Reset this key to the correct value "ON" using the system utility REGEDT32.EXE.


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 4.21 and 4.21a Windows NT clients. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: WINDOWS NT dblib

Keywords : kbusage
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2


Last Reviewed: February 5, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.