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 %>
<!--#include file="../global/adovbs.inc"-->
<%
SET CON=server.createObject ("ADODB.Connection")
CON.Open "Provider=SQLOLEDB;Data Source=XXX;UID=XX;PWD=;Database=XXX"
SET com=server.CreateObject ("ADODB.Command")

dim UserID, ManagerCount, FullName
com.ActiveConnection = CON
com.commandtext=sp_login
com.CommandType = 4

with com
.Parameters.Append com.CreateParameter("@Email",adVarChar,adParamInpu t,50,Request.Form("email"))
.Parameters.Append com.CreateParameter("@Password",adVarChar,adParamI nput,50,Request.Form("password"))
.Parameters.Append com.CreateParameter("@FullName", adVarChar, adParamOutput,4)
.Parameters.Append com.CreateParameter("@UserID", adInteger, adParamOutput,4)
.Parameters.Append com.CreateParameter("@ManagerCount", adInteger, adParamOutput,4)
end with
com.Execute -----------------------------------> Line 19
FullName = com.Parameters("@FullName").Value
UserID = com.Parameters("@UserID").Value
ManagerCount = com.Parameters("@ManagerCount").Value
Response.Write "Succcuss"

%>


Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Syntax error or access violation line 19

com.commandtext="sp_login "