Re: Arguments are of the wrong type message using TADODataSet for simple stored procedure

From: "Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 27 Feb 2006 15:33:49 -0600

"Paul Saxton" <bnew@xxxxxxxxxx> wrote in message
news:440327b3$1@xxxxxxxxxxxxxxxxxxxxxxxxx

Hello

I have a really annoying problem.

I have a simple stored procedure in my SQL Server database

CREATE PROCEDURE SpecificInsert
@nTest as int
AS
GO

This stored procedure will not return a dataset

If the stored proc isn't returning a result set, don't use the TADODataSet
component. Use TADOCommand instead.

Good luck,
krf

.

References:
- Arguments are of the wrong type message using TADODataSet for simple stored procedure
  - From: Paul Saxton

Prev by Date: Arguments are of the wrong type message using TADODataSet for simple stored procedure
Next by Date: Re: Arguments are of the wrong type message using TADODataSet for simple stored procedure
Previous by thread: Arguments are of the wrong type message using TADODataSet for simple stored procedure
Next by thread: Re: Arguments are of the wrong type message using TADODataSet for simple stored procedure
Index(es):
- Date
- Thread

Relevant Pages

Re: Intercepting invalid parameters to a stored procedure
... cuts up the query string into pieces and barks if the input ... idiot-proof stored procedure. ... @OrderNumber int output ... SET @OrderNumber = @@IDENTITY ...
(microsoft.public.dotnet.languages.csharp)
Re: Ignore SQL Server 2000 store proc errors and still get results?
... is occurring in ADO.NET when I try to execute that stored procedure. ... > The problem is in the way you are handling errors in your sproc code. ... > DECLARE @Rows int ... >> BEGIN SETUP TEST - run this script in Query Analyzer ...
(microsoft.public.dotnet.framework.adonet)
Re: Ignore SQL Server 2000 store proc errors and still get results?
... DECLARE @Rows int ... > BEGIN SETUP TEST - run this script in Query Analyzer ... Create the console app ... >> temp table in your stored procedure to handle the collection of valid ...
(microsoft.public.dotnet.framework.adonet)
Re: How to retrieve stored procedure error code in C#?
... @Fred int OUTPUT ... >>> I am able to view these error codes when I run the stored proc in Query ... >>> have seen some mention of the stored procedure having to stuff it into ...
(microsoft.public.dotnet.framework.adonet)
TableAdapter, INNER JOINs, stored procs, and problems with Update
... I have a stored procedure that uses JOINs to return columns from multiple ... I also have another stored proc that that takes a series of params ... @ac2 int, ...
(microsoft.public.dotnet.framework.aspnet)