I am running Ingres Net (version 2.6 SP2) on a Windows Server 2003 box with ODBC Driver version 3.50.00.32 and am having some problems with stability.
Essentially the problem is that I get a random Ingres ODBC error
ERROR [HY000] [CA][Ingres ODBC Driver]Ingres API invalid handle error
We tried to fix the problem by turning connection pooling off however, we continued to get errors of a different kind
ERROR [HY000] [CA][Ingres ODBC Driver]Ingres API failure probably to due to transaction already abnormally terminated
The application that is now running on the server runs fine on a Windows Server 2000 box.
I cant seem to find a way to reproduce the problem as it seems totally random, and the only way that we've found to fix the problem is to either restart Ingres or kill the asp.net worker process.
Has anyone out there had any problems trying to run Ingres on a Windows Server 2003 box