BUG: International Settings Ignored

 Last reviewed: April 30, 1997
Article ID: Q126287

The information in this article applies to:
  • Microsoft SQL Server, versions 4.21 and 4.21a
BUG# NT: 7913 (4.21)

SYMPTOMS

NOTE: This article is specific for Windows NT SQL Server clients.

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 SSrvDB_Lib SSrvWinNT
Version : 4.21 4.21a
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.