Hi Ross,
Look at the stored procedure definition and see if there are any fields which are
used in SP and missing in database (Spelling Mistake, or the field is deleted
recently)... you may want to send the stored procedure definition and the structure of
all the tables used in the stored procedure..
Venu
"Ross St. Clair" <[EMAIL PROTECTED]> wrote:
I'm getting a strange error while attempting to execute a stored
procedure via ADO. I can't figure it out for the life of me and I've
looked all over the place for a solution, but nothing has helped or
really applied to this situation. I'm hoping someone here has an
idea. The error I'm getting is "Item cannot be found in the
collection corresponding to the requested name or ordinal" and is
occurring on the line I marked in the code below. Is it possible
there is something in the stored procedure's code that is causing
this error? I didn't write the SP, but it works fine from Query
Analyzer. Thanks for your help!
-- Ross St. Clair
CODE:
-----
Set cmdCommitMetric = Server.CreateObject("ADODB.Command")
cmdCommitMetric.ActiveConnection = connMain
cmdCommitMetric.CommandText = "sp_MM_Alert_Insert"
cmdCommitMetric.CommandType = adCmdStoredProc
cmdCommitMetric.Parameters.Append
cmdCommitMetric.CreateParameter("@Name", adVarChar, adParamInput)
cmdCommitMetric.Parameters.Append
cmdCommitMetric.CreateParameter("@UMKey", adInteger, adParamInput)
cmdCommitMetric.Parameters.Append
cmdCommitMetric.CreateParameter("@CDays", adInteger, adParamInput)
cmdCommitMetric.Parameters.Append
cmdCommitMetric.CreateParameter("@WDays", adInteger, adParamInput)
cmdCommitMetric.Parameters.Append
cmdCommitMetric.CreateParameter("@NDays", adInteger, adParamInput)
cmdCommitMetric.Parameters.Append
cmdCommitMetric.CreateParameter("@Flg", adVarChar, adParamInput)
cmdCommitMetric.Parameters("@Name").Value = sAlertName
cmdCommitMetric.Parameters("@UMKey").Value = CLng(sUserMetricKey)
cmdCommitMetric.Parameters("@CDays").Value = lCriticalAlertDays
cmdCommitMetric.Parameters("@WDays").Value = lWarningAlertDays
cmdCommitMetric.Parameters("@NDays").Value = lNormalAlertDays
cmdCommitMetric.Parameters("@Flg").Value = sAlertEnabled
Set rsCommitMetric = cmdCommitMetric.Execute
^^^ ERROR OCCURS AS A RESULT OF THIS LINE ^^^
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
