I have a strange problem while running an application using openlink ODBC. This application has been running for several years but this morning it has suddenly stopped working. I can connect fine to the database, but when I run the sql query it fails with SQL STATE S1000, then ORA-6502 and ORA-6512 numeric error. This is on the TEST database and this application runs fine against the PROD database using the Openlink ODBC. I can also run this apps. using Microsoft ODBC driver or Oracle ODBC driver. I can also run the query using just SQLPLUS. We have narrowed it down to the Openlink ODBC driver. My question is what calls to the database does Openlink do? and What set up does the Openlink ODBC need?
Thank you.