|
 |
asp_ado_rds thread: ADODB.Command (0x800A0BB9)
Message #1 by salman.ahmed@r... on Mon, 23 Jul 2001 14:02:54
|
|
Help!!!! Please need some help! Thanks!
Getting the following error:
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range,
or are in conflict with one another.
/Corporation/Dynamic/AspLogon.asp, line 39
------------------------------------------------------------------
Line 39 is:AdoCmd.CommandType = adCmdStoredProc
-------- Here is my code -----------------------------------------
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "DSN=LapDomA;uid=Brain;pwd=Brain"
SET AdoCmd = Server.CreateObject("ADODB.Command")
SET AdoCmd.ActiveConnection = DataConn
AdoCmd.CommandType = adCmdStoredProc
AdoCmd.CommandText = "sp_Logon"
AdoCmd.Parameters.Append AdoCmd.CreateParameter
("Return",adInteger,adParamReturnValue,4)
AdoCmd.Parameters.Append AdoCmd.CreateParameter("User
name",adVarChar,adParmInput,50,Request.Form("User Name"))
AdoCmd.Parameters.Append AdoCmd.CreateParameter
("Password",adVarChar,adParmInput,50,Request.Form("Password"))
AdoCmd.Execute
-----------Here is my storedproc------------------------------------
CREATE PROCEDURE [sp_Logon]
@USERID_1 [varchar](50),
@PASSWORD_2 [varchar](50)
AS
DECLARE @FIRSTNAME_O [varchar](25)
SELECT
@FIRSTNAME_O= [FIRSTNAME]
FROM [IntelliBrain].[dbo].[CORPDISC]
WHERE
[CUSERID] = @USERID_1
AND
[PASSWORD]=@PASSWORD_2
IF @FIRSTNAME_O = NULL
BEGIN
SELECT
@FIRSTNAME_O= [FIRSTNAME]
FROM [IntelliBrain].[dbo].[INDIVDESC]
WHERE
[IUSERID] = @USERID_1
AND
[PASSWORD]=@PASSWORD_2
IF @FIRSTNAME_O <> NULL
RETURN (2)
ELSE
RETURN (0)
END
ELSE
RETURN (1)
Message #2 by Josh King <JoshK@g...> on Mon, 23 Jul 2001 08:30:54 -0500
|
|
You'll want to look at your @Userid_1 parameter in your stored procedure.
Change it @Username and it should work. Your calling the same parameter two
different things.
Josh King
GeoAccess Inc.
xxx.xxx.xxxx x5237
xxx.xxx.xxxx x5237
-----Original Message-----
From: salman.ahmed@r... [mailto:salman.ahmed@r...]
Sent: Monday, July 23, 2001 9:03 AM
To: ASP_ADO_RDS
Subject: [asp_ado_rds] ADODB.Command (0x800A0BB9)
Help!!!! Please need some help! Thanks!
Getting the following error:
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range,
or are in conflict with one another.
/Corporation/Dynamic/AspLogon.asp, line 39
------------------------------------------------------------------
Line 39 is:AdoCmd.CommandType = adCmdStoredProc
-------- Here is my code -----------------------------------------
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "DSN=LapDomA;uid=Brain;pwd=Brain"
SET AdoCmd = Server.CreateObject("ADODB.Command")
SET AdoCmd.ActiveConnection = DataConn
AdoCmd.CommandType = adCmdStoredProc
AdoCmd.CommandText = "sp_Logon"
AdoCmd.Parameters.Append AdoCmd.CreateParameter
("Return",adInteger,adParamReturnValue,4)
AdoCmd.Parameters.Append AdoCmd.CreateParameter("User
name",adVarChar,adParmInput,50,Request.Form("User Name"))
AdoCmd.Parameters.Append AdoCmd.CreateParameter
("Password",adVarChar,adParmInput,50,Request.Form("Password"))
AdoCmd.Execute
-----------Here is my storedproc------------------------------------
CREATE PROCEDURE [sp_Logon]
@USERID_1 [varchar](50),
@PASSWORD_2 [varchar](50)
AS
DECLARE @FIRSTNAME_O [varchar](25)
SELECT
@FIRSTNAME_O= [FIRSTNAME]
FROM [IntelliBrain].[dbo].[CORPDISC]
WHERE
[CUSERID] = @USERID_1
AND
[PASSWORD]=@PASSWORD_2
IF @FIRSTNAME_O = NULL
BEGIN
SELECT
@FIRSTNAME_O= [FIRSTNAME]
FROM [IntelliBrain].[dbo].[INDIVDESC]
WHERE
[IUSERID] = @USERID_1
AND
[PASSWORD]=@PASSWORD_2
IF @FIRSTNAME_O <> NULL
RETURN (2)
ELSE
RETURN (0)
END
ELSE
RETURN (1)
|
|
|
View Cart
