If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: interbase 6.0

hi all!

I'm testing interbase 6 using gemini ODBC conectivity, and Visual C++. I use stored procedures, but when i call a specific non-return values stored procerdure, ODBC shows me an error: state: HY000, native =
-84, procedure xxxxx does not return any values. In fact, such procedure does not return any values, because i don't need it. So, why the error?

Re: interbase 6.0

I don´t know exactly how things work out with ODBC connectivity, but at least I received exactly the same error message using Firebird server and .NET Data Provider.

My misktake was to invoke the stored procedure with the wrong method call. With .NET there´s a method called "ExecuteNonQuery" which should be the right one for this kind of stored procedures.

Maybe with ODBC it´s similar?

Best regards,
Mark.

Originally posted by accarvajal
hi all!

I'm testing interbase 6 using gemini ODBC conectivity, and Visual C++. I use stored procedures, but when i call a specific non-return values stored procerdure, ODBC shows me an error: state: HY000, native =
-84, procedure xxxxx does not return any values. In fact, such procedure does not return any values, because i don't need it. So, why the error?