#23 Stored Procedures parameters problems

open
nobody
None
5
2005-03-11
2005-03-11
leandesbuilder
No

Hi,
I'm trying to invoke a Stored Procedure on MS-SQL
Server 2000 and the ODBC throws an exception saying
that the procedure expects a parameter that was not
supplied, but it was!
It's seems a parameter binding problem. No parameter
beign configured for the ODBC call...
The complete error message is:
*****************************************************************
'Error returned from ODBC function SQLExecute
ODBC Return Code: -1: SQL_ERROR

ODBC SqlState:42000
Native Error Code:201
[Microsoft][ODBC SQL Server Driver][SQL Server]
Procedure <proc-name> expects parameter <param-
name>, which was not supplied.

DBMS: "Microsoft SQL Server", version: 08.00.0760,
ODBC Driver: "SQLSRV32.DLL", version: 03.85.1117

SQL:
"<proc-name>"

Parameters:
1 OUTPUT
2 INPUT INTEGER: 208419
3 INPUT TIMESTAMP: 2004-04-20 09:03:05.000000000
4 INPUT TIMESTAMP: 2004-07-19 00:00:00.000000000
5 INPUT VARCHAR: '0000000206733'
6 INPUT VARCHAR: [NULL]
7 INPUT VARCHAR: [NULL]
8 INPUT VARCHAR: [NULL]
9 INPUT DECIMAL(8,2): 0
10 INPUT DECIMAL(4,2): 17.11
11 INPUT INTEGER: 206733
12 INPUT VARCHAR: [NULL]
13 INPUT VARCHAR: [NULL]
14 INPUT LONGVARBINARY: [NULL]
15 INPUT VARCHAR: '1642 '
16 INPUT TIMESTAMP: [NULL]
17 INPUT SMALLINT: 2004
18 INPUT SMALLINT: 7
19 INPUT LONGVARBINARY: [NULL]
20 INPUT TIMESTAMP: [NULL]
21 INPUT VARCHAR: 'A9E92AE7C8695B59'
22 INPUT VARCHAR: '2'
23 INPUT INTEGER: 1830

Connection string:
DSN=<DSNname>;UID=<username>;PWD=***;DB=<DB
name>;LANG=english'
*****************************************************************

Discussion