Microsoft KB Archive/185870

= SQL Server Insert Error Regarding Column Name Mismatch =

Article ID: 185870

Article Last Modified on 6/23/2005

-

APPLIES TO


 * Microsoft Windows NT Server 4.0, Terminal Server Edition
 * Microsoft Internet Information Server 3.0

-



This article was previously published under Q185870



We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx



SYMPTOMS
On high-volume computers running Internet Information Server 3.0, the Internet Server service may appear to stop responding (hang) while attempting to connect to a SQL Server computer. The following error message appears:

State 21S01 Error 213

Microsoft ODBC SQL Server Driver

SQL Server Insert error: column name or number of supplied values does

not match table definition..



CAUSE
This is caused by a problem with the allocation parameter passed between the Internet Database Connector (Httpodbc.dll) and the Microsoft Internet Information Services Helper library (Infocomm.dll).



RESOLUTION
To resolve this problem, obtain the latest service pack for Windows NT 4.0 or Windows NT Server 4.0, Terminal Server Edition. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

152734 How to Obtain the Latest Windows NT 4.0 Service Pack



STATUS
Microsoft has confirmed this to be a problem in Internet Information Server version 3.0. This problem was first corrected in Windows NT 4.0 Service Pack 4.0 and Windows NT Server 4.0, Terminal Server Edition Service Pack 4.

Keywords: kbbug kbfix KB185870

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.