Unanswered: sp_password is working but returns error code
I'm using ODBC to connect to sybase.
When I try to execute:
sp_password 'passOld', 'passNew'
the ODBC get's return status from SqlExecute = 1 and a "Password correctly set." message. This SqlStatus is logged as an error and I can't find a way to go around it. I've tried 24 combinations (with doublequotes, single quotes, no quotes around passwords; with/without exec in front, with/without username...) and all of them succeed but none returns 0
I've googled and found that someone also had the same problem, but he suppressed errors, which I musn't do...
Does anyone have any idea why is this happening? Is it up to ODBC driver or Sybase? And what would be eventual solution?