PROBS ON ASP CODE - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

PROBS ON ASP CODE

Author

Topic

MATTXtwo
Starting Member

4 Posts

Posted - 2008-09-24 : 20:58:20

[code]dim val
set rm = Server.CreateObject ("ADODB.Command")
rm.ActiveConnection=OBJdbConnection
rm.CommandText="exec get_user"

rm.Parameters.Append rm.CreateParameter("RETURN",adInteger,adParamReturnValue,4)

rm.Parameters.Append rm.CreateParameter("@user_id",adVarChar,adParamInput,8,NoStaf)

rm.Parameters.Append rm.CreateParameter("@pwd",adVarChar,adParamInput,12,Pwd)
rm.Execute
val=rm.Parameters("RETURN").Value
[/code]

---------------------------------------------------------------------ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/Intranet/MainVal2.asp, line 14

BRINGING LITE CONTENTS

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-09-24 : 21:06:38

Is this related to SQL Server Admin?

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-25 : 01:23:15

quote:
Originally posted by sodeep

Is this related to SQL Server Admin?

Obviously not. This is a .net forum, but a Classic ASP question
Should have been posted here
http://www.sqlteam.com/forums/forum.asp?FORUM_ID=18

You havent set the variable constants for the parameters you are passing. Which of the above is line 14 ?

see this link

http://support.microsoft.com/default.aspx/kb/254517

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-25 : 02:04:07

Change this

rm.Parameters.Append rm.CreateParameter("RETURN",adInteger,adParamReturnValue,4)

to this

rm.Parameters.Append rm.CreateParameter("@RETURN",adInteger,adParamReturnValue,4)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources