dany marois

Hi,

We have make a call to a stored procedure in SQL SERVER 2000 via un driver
ODBC and we have a error return by sql server. The code of the native error
is 119 and the dsecription is:

Must pass parameter number 3 and subsequent parameters as '@name = value'.
After the form '@name = value' has been used, all subsequent parameters must
be passed in the form '@name = value'.

This is our call to the storedProc:

{call StoredProcTest(?, ?, 'ABC')}

And this the declaration of the stored proc:

CREATE PROCEDURE StoredProcTest
@intRetrCode int OUTPUT,
@strErrorMesg varchar(200) OUTPUT,
@strNoDosr varchar(20) AS

BEGIN

.... Code here


END;

Anyone have an idea of the problem. We use