Isaac
asked on
ADODB.Parameter error '800a0d5d'
I have the following stored procedure and beloow it I have a piece of the ASP file that calls it.
This is the error I get:
ADODB.Parameter error '800a0d5d'
Application uses a value of the wrong type for the current operation.
/pp/processTRequest.asp, line 62
ALTER PROCEDURE [dbo].[sp_insUserInfo]
-- Parameters for 'tbl_user'
@personnel_id int,
@fname varchar(50),
@lname varchar(50),
@username varchar(50),
@pwd varchar(50),
@role_ID int,
@email_addr varchar(70)
AS
DECLARE @dte_added datetime
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @dte_added = GETDATE()
INSERT INTO tbl_user(personnel_id,fnam e,lname,us ername,pwd ,role_id,e mail_addr, dte_added) VALUES(@personnel_id,@fnam e,@lname,@ username,@ pwd,@role_ ID,@email_ addr,@dte_ added)
--return SCOPE_IDENTITY()
END
'========================= ========== ==========
'Stored Procedure - sp_insUserInfo
'========================= ========== ==========
Set cmd = server.CreateObject("ADODB .Command")
WITH cmd
.ActiveConnection = Conn
.CommandText = "sp_insUserInfo"
.CommandType = adCmdStoredProc
.Parameters(1).Value = session("pid")
.Parameters(2).Value = session("firstname")
.Parameters(3).Value = session("lastname")
.Parameters(4).Value = session("username")
.Parameters(5).Value = session("password")
.Parameters(6).Value = session("roleID")
.Parameters(7).Value = session("email") <-- Line 62
.execute()
END WITH
When I take out line 62 and comment it out of my SP, I don't get an error.
what am I doing wrong?
Thanks.
This is the error I get:
ADODB.Parameter error '800a0d5d'
Application uses a value of the wrong type for the current operation.
/pp/processTRequest.asp, line 62
ALTER PROCEDURE [dbo].[sp_insUserInfo]
-- Parameters for 'tbl_user'
@personnel_id int,
@fname varchar(50),
@lname varchar(50),
@username varchar(50),
@pwd varchar(50),
@role_ID int,
@email_addr varchar(70)
AS
DECLARE @dte_added datetime
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SET @dte_added = GETDATE()
INSERT INTO tbl_user(personnel_id,fnam
--return SCOPE_IDENTITY()
END
'=========================
'Stored Procedure - sp_insUserInfo
'=========================
Set cmd = server.CreateObject("ADODB
WITH cmd
.ActiveConnection = Conn
.CommandText = "sp_insUserInfo"
.CommandType = adCmdStoredProc
.Parameters(1).Value = session("pid")
.Parameters(2).Value = session("firstname")
.Parameters(3).Value = session("lastname")
.Parameters(4).Value = session("username")
.Parameters(5).Value = session("password")
.Parameters(6).Value = session("roleID")
.Parameters(7).Value = session("email") <-- Line 62
.execute()
END WITH
When I take out line 62 and comment it out of my SP, I don't get an error.
what am I doing wrong?
Thanks.
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=281612
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.