I have an app that I'm trying to call a mysql stored proc and return an integer values. The proc always returns 1. If I exec the proc from within a query window in mysql it returns a -5 (for update).
I've attached the code for the proc and vb call. I know it would be easier to use the mysql connector stuff but I'm not allowed to.
The mysql version is 5.0.91