stored procedure error in asp?

A

anand

Well-known member
Joined
Jan 29, 2003
Messages
76
Location
chicago
Hi i am getting the following error
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/anand/sqlcon2.asp, line 14

my code is

Code: 
<html>
<body bgcolor="lightyellow">
<%

Dim conn,cmd 
dim rs1
set rs1=server.createobject("adodb.recordset")
Set conn = Server.CreateObject("ADODB.Connection")
set cmd=server.createobject("adodb.command")
conn.Open "DSN=AnandDSN;uid=sa;password=;"

cmd.activeconnection=conn
cmd.commandtext="proc1"
cmd.commandtype=adCmdStoredProc
rs1=cmd.execute()


%>

</body>
</html>


procedure code is
----------------------


create procedure proc1   
as  
begin  
select * from test  
end
here it returns 3 rows


pls tell me whats my mistake and whats the correct code....
pls giveme idea ..its very urgent to me...
Thank you
Satya
 
Last edited by a moderator:
Hi robby
Thank you for ur time...its working fine now...
just u add the set key word
thank you
Anand
 
Back
Top