PRB: Too Many Arguments Supplied for Procedure sp_MShelpcolumns (193228)


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
  • Microsoft SQL Server 6.5
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:
  1. Open Enterprise Manager.
  2. Right-click the SQL Server you wish to check and select Configure.
  3. Click the Attributes tab.
  4. 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

STATUS

This behavior is by design.

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:5/29/2003
Keywords:kbCtrl kberrmsg kbide kbprb KB193228
©2002 Microsoft Corporation. All rights reserved.