BUG: International Settings Ignored

ID: Q126287

The information in this article applies to:

Microsoft SQL Server versions 4.21, 4.21a

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 : winnt:4.21,4.21a
Platform : winnt
Issue type :