Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    3

    Unanswered: Microsoft OLE DB Provider for SQL Server (0x80040E14)

    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

  2. #2
    Join Date
    Dec 2004
    Location
    York, PA
    Posts
    95
    com.commandtext="sp_login "

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •