PRB: Too Many Arguments Supplied for Procedure sp_MShelpcolumns

ID: Q193228

The information in this article applies to:

Microsoft Visual InterDev, version 6.0

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

Installing SQL 6.5 Service Pack 4 updates the stored procedure with one that accepts more arguments. You can download SQL Server Server Pack 4 at this location:

http://support.microsoft.com/support/downloads/

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

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

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Create a new Web project with Visual InterDev 6.0.

Add a Data Connection to a SQL 6.5 database that has not been updated with Server Pack 3.

Add a new ASP page to the project.

Add a Recordset DTC to the page.

Drag the Grid control to the page.

Additional query words:

Keywords : kbCtrl kbide kbSQLServ kbVisID600 kbGrpASP
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type : kbprb