Arguments are of the wrong type message using TADODataSet for simple stored procedure
- From: "Paul Saxton" <bnew@xxxxxxxxxx>
- Date: Mon, 27 Feb 2006 16:24:20 -0000
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
I have then added a TADODataSet component to my form
object ADODataSet2: TADODataSet
Connection = DB
ExecuteOptions = [eoAsyncExecute, eoExecuteNoRecords]
CommandText = 'SpecificInsert;1'
CommandType = cmdStoredProc
Parameters = <
item
Name = '@RETURN_VALUE'
DataType = ftInteger
Direction = pdReturnValue
Precision = 10
Value = 0
end
item
Name = '@nTest'
Attributes = [paNullable]
DataType = ftInteger
Precision = 10
Value = 1
end>
Prepared = True
Left = 466
Top = 5
end
When I try to make the dataset active - as in run the stored procedure - I
get the "Arguments are of the wrong type or are in conflict with each other"
message
This is really annoying me now, I have never tried this before, would I be
better using a command?
Cheers
Paul
.
- Follow-Ups:
- Prev by Date: Re: Problem using TADOStoredProc with MS Access XP
- Next by Date: Re: Arguments are of the wrong type message using TADODataSet for simple stored procedure
- Previous by thread: Problem using TADOStoredProc with MS Access XP
- Next by thread: Re: Arguments are of the wrong type message using TADODataSet for simple stored procedure
- Index(es):
Relevant Pages
|
