I have a MS Access 2013 application that opens an ODBC connection to an Oracle database via an Oracle client (126.96.36.199). On occasion the application returns the following error when the ODBC connection is opened:
Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraClient12Home1_32bit, C:\oracle\product\12.1.0\client_1\SQORA32.DLL).
This is an intermittent problem that is reproducible on several workstations (all running Windows 7 x64 with 32-bit version of Office 2013 and 32-bit Oracle client).
- Problem occurs with 11gR2 and 12c Oracle clients tested so far
- Many times the ODBC connection is established without a problem
- Other times the connection can be established by re-running the application a few times
The same application is being run on several workstations. Not every user experience the problem at the same time. The problem may be chronic but intermittent for one user whereas another user experiences no problem whatsoever, until they do.
All of the posts I have seen concerning this issue are for a persistent problem opening a connection and not an intermittent one. I am at a loss of how to diagnose this problem. The feedback from MS Windows discussion groups claim that this is not a Windows problem. I would appreciate some direction.