[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

SV: Parameter Mismatch



Hello,
we have the same environment, and it works fine for us.
Though, I have noticed a difference from SqlServer 6.5.
7.0 is delivering the OUTPUT parameters as a result set, so if you have for
example a display in a stored procedure, it will disturb the parameter
delivery.

/Christer A.

> -----Ursprungligt meddelande-----
> Från: Dave Ingram [SMTP:Dave_Ingram@NAS.ADP.COM]
> Skickat:      den 3 november 2000 20:00
> Till: SQR-USERS@LIST.IEX.NET
> Ämne: Parameter Mismatch
>
> Hello List,
>
> We are running SQR 6 against SQL-Server 7.
>
> One of the jobs produces the error "Formal parameter '@P5' was defined as
> output but the actual parameter not declared output" from ODBC.
>
> Is this a problem with the way SQR is creating or executing the stored
> procedure for the SQL?  Can anyone shed some light?
>
> di