Database connection error: ADODB.Command error '800a0cc1'

[DragonFields]

I'm hoping someone can help me. I keep receiving the ADODB.Command error '800a0cc1' error (Item cannot be found in the collection corresponding to the requested name or ordinal.) I found a couple similar errors on the discussions but am not tracking how to apply the fixes into my code, which of course is slightly different...I'm using Visual Interdev 6.0 with MS SQL Enterprise Mgr 8.0. I'm linking an .asp page to a stored procedure and I've simplified both to find the error to no avail...

ASP:
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Set Cmd = Server.CreateOb ject("ADODB.Com mand")
Conn.Connection String = "Provider=SQLOL EDB.1;Persist Security Info=False;User ID=XXuser;Passw ord=XXuser;Init ial Catalog=OPGIntr anet;Data Source=PDXsrv57 "
Conn.Open
Set Cmd.ActiveConne ction = Conn
strLogonId = Request.ServerV ariables("LOGON _USER")
Response.Write strLogonId
Cmd.CommandType = 4 'adCmdStoredPro c
Cmd.CommandText = "usp_Get_UserDa ta" 'ERROR LINE
Cmd.Parameters( "@parm_UserLogo n").Value = strLogonId
Cmd.Execute()
strUserFirstNam e = Cmd.Parameters( "@parmOut_UserF irstName").Valu e
Set Cmd = Nothing
Set Conn = Nothing

Stored Procedure: (usp_Get_UserDa ta)
@parm_UserLogon NetworkLogon,
@parmOut_UserFi rstName varchar(20) OUTPUT
AS
SET @parmOut_UserFi rstName = 'Debbie'
GO

Thanks all!

[ilearneditonline]

Look at this post... Link

I'm hoping someone can help me. I keep receiving the ADODB.Command error '800a0cc1' error (Item cannot be found in the collection corresponding to the requested name or ordinal.) I found a couple similar errors on the discussions but am not tracking how to apply the fixes into my code, which of course is slightly different...I'm using Visual Interdev 6.0 with MS SQL Enterprise Mgr 8.0. I'm linking an .asp page to a stored procedure and I've simplified both to find the error to no avail...

ASP:
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Set Cmd = Server.CreateOb ject("ADODB.Com mand")
Conn.Connection String = "Provider=SQLOL EDB.1;Persist Security Info=False;User ID=XXuser;Passw ord=XXuser;Init ial Catalog=OPGIntr anet;Data Source=PDXsrv57 "
Conn.Open
Set Cmd.ActiveConne ction = Conn
strLogonId = Request.ServerV ariables("LOGON _USER")
Response.Write strLogonId
Cmd.CommandType = 4 'adCmdStoredPro c
Cmd.CommandText = "usp_Get_UserDa ta" 'ERROR LINE
Cmd.Parameters( "@parm_UserLogo n").Value = strLogonId
Cmd.Execute()
strUserFirstNam e = Cmd.Parameters( "@parmOut_UserF irstName").Valu e
Set Cmd = Nothing
Set Conn = Nothing

Stored Procedure: (usp_Get_UserDa ta)
@parm_UserLogon NetworkLogon,
@parmOut_UserFi rstName varchar(20) OUTPUT
AS
SET @parmOut_UserFi rstName = 'Debbie'
GO

Thanks all!