I'm executing a stored procedure using
OdbcCommand.ExecuteScalar() method and got an ODBC SQL
Server Driver "Function Sequence Error". Below are the two
sps (one generates the ODBC driver error, the other one
doesn't). Has anyone ever had a similar problem?

-- ODBC Function sequence error when executing this sp
-- On the ODBC trace file, error 50001 was returned first,
then an ODBC "Function Sequence Error" was returned.

CREATE PROC sp_Test
@TestInput int
, @TestOutput int OUT
AS

DECLARE @error int

RAISERROR 50001 'Test'
SELECT @error = @@ERROR

RETURN @error
GO





-- NO ODBC Function sequence error when executing this sp
-- The correct error passed back properly (50001)
CREATE PROC sp_Test
@TestInput int
, @TestOutput int OUT
AS
RAISERROR 50001 'Test'
GO