Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Ado Data RDS > SP OUTPUT VALUE...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 10 Topic 254 of 305
Post > Topic >>

SP OUTPUT VALUE PROBLEM

by "Savas Ates" <savas@[EMAIL PROTECTED] > Jun 6, 2005 at 06:24 PM

ERROR
Error Type: ADODB.Command
(0x800A0BB9) Arguments are of the wrong type, are out of acceptable range,

or are

line :  .Parameters.Append .CreateParameter("@[EMAIL PROTECTED]
", adInteger, 
adParamInput)


MYPROC IS

CREATE PROCEDURE st_myProc

@[EMAIL PROTECTED]
 INT , @[EMAIL PROTECTED]
 INT OUTPUT
 AS
SET @[EMAIL PROTECTED]
 CODE WITH ADO


set cmd=server.CreateObject ("ADODB.Command")
 Set cmd.ActiveConnection = baglantim
cmd.CommandText = "st_myProc"
cmd.CommandType = 4
 with cmd
    .Parameters.Append .CreateParameter("@[EMAIL PROTECTED]
", adInteger,
adParamInput)
    .Parameters.Append .CreateParameter("@[EMAIL PROTECTED]
", adInteger,
adParamInput)
 end with

Set rs = cmd.Execute
Dim i
While Not rs.EOF
Response.Write rs.Fields(i)&" "
 i = i + 1

rs.MoveNext

Wend
 




 10 Posts in Topic:
SP OUTPUT VALUE PROBLEM
"Savas Ates" &l  2005-06-06 18:24:53 
RE: SP OUTPUT VALUE PROBLEM
=?Utf-8?B?SmVmZnJleSBLLiB  2005-06-06 08:24:05 
Re: SP OUTPUT VALUE PROBLEM
"Savas Ates" &l  2005-06-06 18:36:34 
Re: SP OUTPUT VALUE PROBLEM
"Rick Sawtell"   2005-06-06 10:29:42 
Re: SP OUTPUT VALUE PROBLEM
"Daniel Crichton&quo  2005-06-06 16:37:37 
Re: SP OUTPUT VALUE PROBLEM
"Savas Ates" &l  2005-06-06 19:24:24 
Re: SP OUTPUT VALUE PROBLEM
"Bob Barrows [MVP]&q  2005-06-06 12:52:39 
Re: SP OUTPUT VALUE PROBLEM
"William \(Bill\) Va  2005-06-06 10:04:07 
Re: SP OUTPUT VALUE PROBLEM
"Daniel Crichton&quo  2005-06-07 12:37:35 
Let this SQL Server ADO.NET code generator write the code for yo
"Robbe Morris [C# MV  2005-06-09 22:19:24 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:17:59 CST 2008.