DevOps, CI/CD and Automation

We are trying to access an Oracle 9.1 database through a Crystal report that uses the Oracle ODBC driver v9.02. The report is generated through an ASP page running on IIS 6 and a Windows 2003 server.

We get a popup on the server console intermittently with the following error:

Oraoledbpus.dll: The specified module could not be found

We have checked the security settings on the Oracle Home directory and assigned appropriate access to all the following:

Administrators
SYSTEM
Authenticated Users
IUSR
ASPNET

We have also checked that the Oracle Home bin directory is in the PATH. This dll does exist in the bin directory. When the report is run in the Crystal Reports designer there is no problem. The strange things is that the Data Source used by the report is ODBC and not Ole DB.

Any ideas or suggestions would be much appreciated.