I am experienced in VB6 and MSSQL, but new to VB2010 and SyBase.
I have an VB2010 application that performs a few INSERT, UPDATE and SELECT queries on a Adaptive Server Anywhere 9 db.
Running in debug mode I get the error "[Sybase][ODBC Driver][Adaptive Server Anywhere]Resource governor for 'prepared statements' exceeded"
Having trouble pinning down what causes error because it does not occur in same place all the time and not having much luck finding out how to fix.
Research on SyBase seems to indicate a db bug.
Can anyone offer any suggestions?
I will be happy to provide code or other information, but at this point I'm not sure what is needed.
Thanks in advance.