Microsoft KB Archive/126287

{|
 * width="100%"|

BUG: International Settings Ignored

 * }

Q126287

-

The information in this article applies to:


 * Microsoft SQL Server version 4.2x

-

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