I am using a stored Procedure in my ASP code to validate the login details, but i am not able to figure out what ADODB.Command(0x800A0BB9) mean. i have included the code as follows


Stored Procedure
================
create Procedure sp_Login
(
@Email varchar(50),
@Password varchar(50),

@FullName varchar(100) output,
@UserID int output,
@ManageCount int output
)
As
select @UserID = 0
select @UserID = UserID, @FullName = FirstName + ' ' + LastName
from Users
where Email like @email + '%'
and password = @Password

if @@rowcount <> 1
begin
select @UserID = 0
return
end

select @ManageCount = count(*)
from Users
where ManagerID = @UserID

=================

<%@ Language=VBScript %>
<% SET CON=server.createObject ("ADODB.Connection")
CON.Open "Provider=SQLOLEDB;Data Source=xxx;UID=sa;PWD=;Database=xxx"
SET com=server.CreateObject ("ADODB.Command")

dim UserID, ManagerCount, FullName,Mail,Pass
Mail = Request.Form("Email")
Pass = Request.Form("Password")

com.ActiveConnection = CON
com.commandtext=sp_login
com.CommandType = 4

with com
.Parameters.Append com.CreateParameter("@Email",adVarChar,adParamInpu t,50,Mail) ---> line 12
.Parameters.Append com.CreateParameter("@Password",adVarChar,adParamI nput,50,Pass)
.Parameters.Append com.CreateParameter("@FullName", adVarChar, adParamOutput)
.Parameters.Append com.CreateParameter("@UserID", adInteger, adParamOutput)
.Parameters.Append com.CreateParameter("@ManagerCount", adInteger, adParamOutput)
end with
FullName = com.Parameters("@FullName").Value
UserID = com.Parameters("@UserID").Value
ManagerCount = com.Parameters("@ManagerCount").Value
%>

''''Error Occured

'ADODB.Command (0x800A0BB9)
'Arguments are of the wrong type, are out of
'acceptable range, or are in conflict with one
'another line 12


Can Any one Plz Reply..

values of adVarChar or adInteger are actually constants of the object and it doesn't look like you are including the adovbs.inc file to create the constants. Here is a good link for you to read up on:

http://msdn.microsoft.com/library/de...invbscript.asp

That will tell you where to get the file and how to include a file in an asp file if you do not know how to.

HTH
DMW

Hi Thank u very much for the solution, i worked....