Powerbuilder 12.5 and SQL Anywhere 11 app fails certain sql statements

We stumbled across this post at the Sybase SQL Forum "I have an application that was developed in PB 12.5 build 2511 and it uses SQL Anywhere database version 11.0.1.2584. When I run the app from PB everything is fine and app works great, however when I create the exe and deploy it on my test box suddenly some of the sql statements simply stop working. sqlca code is -1."

Check out where it went wrong.