Microsoft KB Archive/193228

= PRB: Too Many Arguments Supplied for Procedure sp_MShelpcolumns =

Article ID: 193228

Article Last Modified on 5/29/2003

-

APPLIES TO


 * Microsoft Visual InterDev 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q193228



SYMPTOMS
When adding Design-Time Controls (DTCs) such as the Grid Control, the following dialog box appears when selecting a table:

ADO error: [Microsoft][ODBC SQL Server Driver][SQL Server]Too many arguments supplied for procedure sp_MShelpcolumns



CAUSE
Visual InterDev 6.0 controls use this stored procedure to populate the drop- down boxes of the control with data from the recordset, such as Table and field names from the database.

Visual InterDev 6.0 controls use the newer version of this stored procedure to do this. Older versions do not take as many parameters as are passed by the Visual InterDev 6.0 Data-bound design-time controls.



RESOLUTION
To update the stored procedure with one that accepts more arguments, install SQL Server 6.5 Service Pack 4. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

178295 How to Obtain SQL Server 6.5 Service Pack 4

Use the following steps to determine which service pack (if any) your SQL Server database is running:  Open Enterprise Manager. Right-click the SQL Server you wish to check and select Configure. Click the Attributes tab.  The ProductVersion values are as follows:      6.50.201 - no service pack 6.50.240 - service pack 2 6.50.258 - service pack 3 6.50.281 - service pack 4 6.50.415 - service pack 5 6.50.416 - service pack 5a 6.50.479 - post service pack 5 update

Or, type "Select @@version" from the ISQL window. This will return a version number that correlates to a Service Pack:      6.50.201 - no service pack 6.50.240 - service pack 2 6.50.258 - service pack 3 6.50.281 - service pack 4 6.50.415 - service pack 5 6.50.416 - service pack 5a 6.50.479 - post service pack 5 update 

<div class="status_section">

STATUS
This behavior is by design.

<div class="moreinformation_section">

Steps to Reproduce Behavior

 * 1) Create a new Web project with Visual InterDev 6.0.
 * 2) Add a Data Connection to a SQL 6.5 database that has not been updated with Server Pack 3.
 * 3) Add a new ASP page to the project.
 * 4) Add a Recordset DTC to the page.
 * 5) Drag the Grid control to the page.

A dialog box appears showing the above error.

Keywords: kberrmsg kbide kbprb kbctrl KB193228

-

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

© Microsoft Corporation. All rights reserved.