> > Hi all,
> >
> > I have a stored procedure which I try to execute from my ASP

page. I

> > have checked all the parameters and the types are correct and

even

> > when I run some simpel tests I get this error message:
> >
> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > Dynamic SQL Error SQL error code = -804 Incorrect values within
> > SQLDA structure
> >
> > I have found a lot of information on the internet about some old

IB

> > bug which might be causing this, but a real answer I couldnt

find.

> >
> > My question to you is, what is going on here? Am I doing

something

> > wrong (is there something that needs some extra attention?) or

has

> > this still got something to do with that old bug????
> >
> > Thanks in advance
> > Gerwin
>
> show us the ASP code. I use SPs in ASP all the time with no errors.
> Alan

Here is the asp code:

'create the stored produre command
Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn

cmd.CommandText = lProcedureName
cmd.CommandType = adCmdStoredProc

cmd.Parameters.Refresh

'set the stored procedure parameters
for lCount = 0 to UBound(arrColumnnames)
if arrProcedureNames(lCount) = lProcedureName and not trim
(lProcedureName) = "" then

'create command parameters
cmd.Parameters(arrColumnNames(lCount)).Value = arrValues(lCount)
end if
next

set rs = cmd.execute

' end of code


There are no problems when I set the values for the parameters, I
only get the message when I execute the cmd. Maybe it is something
small and I just dont see it. Like I said, i have checked all of the
types and as far as I can tell, they all correspond to the types in
the database.