I'm working on integrating a Cache database into an existing .NET project of mine. I'm trying to execute certain queries utilizing the Cache ODBC driver. The first error I ran into was "[S1000] [Cache ODBC][State : S1000][Native Code 417] Access Denied". The part that's throwing me for a loop though is that the application ran ~200 successful queries before I started getting that. After some of those Access Denied errors, they turned into "[Cache ODBC][State : S1T00][Native Code 450] Request timed out due to user timeout". This was all with the regular (2.5?) driver.
I then started using the 3.5 driver. But, the same scenario played out again. The only difference being the State: from S1000 to HY000. These then also turned into "Request timed out due to user timeout" with a state of HYT00 instead of S1T00.
Has anyone seen this before? The fact that it doesn't start happening until after many successful queries have occurred has left me stuck. Are there any initial steps I should take to try to troubleshoot this?