[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
SV: Parameter Mismatch
- Subject: SV: Parameter Mismatch
- From: Andersson Christer Konsult <christer.andersson@SIF.SE>
- Date: Mon, 6 Nov 2000 09:03:01 +0100
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