PRB: Too Many Arguments Supplied for Procedure sp_MShelpcolumnsID: Q193228
|
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
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.
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:
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
This behavior is by design.
Additional query words:
Keywords : kbCtrl kbide kbSQLServ kbVisID600 kbGrpASP
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type : kbprb
Last Reviewed: May 27, 1999