Stored Prod Param Help

From: Lou Feliz (lrf05_at_nospam.csufresno.edu)
Date: 12/23/03 

Date: Mon, 22 Dec 2003 23:25:56 -0800

I am using ADO with SQL 7 and want to pass a parameter to a SP that will
return a string. My SP has one input param and one output parm. The
input parm is @Name and the output parm is VALUE

The parameters are set to the correct type. I try and set parameter by
calling TSTProc.Parameters[1].Value := 'INPUTVAL'. At runtime I get an
OleException - Parameter Object is improperly defined or inconsistent info
provided.

I will revert o using a simple query to pull the values. Although, a SP is
what my DBA wants me to use.

Any help greatly appreciated.

- Lou

Relevant Pages

  • Re: getObject() and shell automation question
    ... > Dim strPathToMDWFile As String, ... > ' ' Open the secured database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Left(), Mid(), Right()
    ... >> The way I read your reply, you are talking about the input param. ... >> string instead of a variant. ... >Replace, Date and Time functions). ...
    (microsoft.public.vb.general.discussion)
  • Re: Left(), Mid(), Right()
    ... "alpine" wrote in message ... > The way I read your reply, you are talking about the input param. ... > string instead of a variant. ...
    (microsoft.public.vb.general.discussion)