Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > OBDC call to stored proc error 119
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 6th August 23:03
dany marois
External User
 
Posts: 1
Default OBDC call to stored proc error 119


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
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666