We have an application with an Access 2002 Front end, linked via Oracle's ODBC driver to Oracle 8.1.5 databases running on 2 IBM RS6000's under UNIX. Much of the coding of the application is done using Oracle triggers.
With the application is an Access "Comprehensive" report that retrieves data from 2 RS6000's, as well as documents stored on Windows 2000 servers and prepares a PDF of every form and document pertaining to the report using Adobe Acrobat 6.0 with Adobe SDK. At the beginning of its run, using Oracle triggers, the report loads all data from the RS6000 into temporary tables in the microsoft access database.
Too often, when one instance of the report and multiple instances of the application are running, all will terminate with the error "ODBC --call failed: [Oracle][ODBC][Ora]ORA-03114: Not connected to ORACLE (#3114)".
How do I rectify this problem as Comprehensive reports must be run throughout the day? Are there any settings on the Oracle ODBC driver than can rectify this? Both the Application and the Comprehensive report are mde files.