Forum Stats

  • 3,769,514 Users
  • 2,252,971 Discussions
  • 7,875,069 Comments

Discussions

Error loading cx_Oracle module in IIS and CGI

liangchen76
liangchen76 Member Posts: 49
edited Jul 8, 2015 12:06AM in Python

I wrote a simple python script to run inside IIS as web-CGI. Python 2.7.5 and Oracle client 12.1 32-bit and cx_Oracle-5.2-12c.win32-py2.7.exe. cgi-python is enabled in IIS with CGI module and the py script mapping.

The script ran fine as standalone outside IIS on the server, which I think could prove all modules properly are installed on the server. But when invoked from the IIS, the script failed to load the oracle dll: DLL load failed: The specified module could not be found. ORACLE_HOME and python home are set into PATH. Read & execute on ORACLE_HOME is granted to server\users and iis_iusrs. app-pool identity and physical path credential is the local admin. Enable 32-bit app is set True.

I still believe this must be caused by the missing path or permission for the account running IIS. But I couldn't think of anything else to add.

Any help or suggestion would be appreciated.

This discussion has been closed.