Forum Stats

  • 3,770,743 Users
  • 2,253,162 Discussions
  • 7,875,573 Comments

Discussions

Win 2019 IIS PHP 7 Oracle client connection issues

user7799027
user7799027 Member Posts: 8
edited Jul 1, 2020 2:55AM in PHP

The set up is

Windows 2019

IIS plus CGI addon

Web Platform Installer

PHP 7.4 64 bit

Oracle 64 bit ODAC 12.2c Release 1(12.2.0.1.1) for Windows x64

Oracle 11g back end database

Web site up and html pages load

phpinfo shows PHP running

Using SQLPLUS I can connect to the 11g Oracle back end database

Trying to make the connection to Oracle back end via the PHP pages fails!!!

Note. The PHP web app runs fine on PHP 5 with Xamp on Windows 2008 and PHP 7.3 with IIS on Windows 2016.

Error in PHP logs...

[02-Jun-2020 12:13:15 UTC] PHP Warning: PHP Startup: Unable to load dynamic library ‘php_oci8_12c.dll’ (tried: C:\Program Files\PHP\v7.4\ext\php_oci8_12c.dll (The specified module could not be found.), C:\Program Files\PHP\v7.4\ext\php_php_oci8_12c.dll.dll (The specified module could not be found.)) in Unknown on line 0

php_oci8_12c.dll is confirmed in the C:\Program Files\PHP\v7.4\ext\ folder.

Note. The prefix and suffix addition in the log error.

php ini exert…

[WebPIChanges]

error_log=C:\Windows\temp\PHP74x64_errors.log

upload_tmp_dir=C:\Windows\temp

session.save_path=C:\Windows\temp

cgi.force_redirect=0

cgi.fix_pathinfo=1

fastcgi.impersonate=1

fastcgi.logging=0

max_execution_time=300

date.timezone=Europe/London

extension_dir=“C:\Program Files\PHP\v7.4\ext”

[ExtensionList]

extension=php_mysqli.dll

extension=php_mbstring.dll

extension=php_gd2.dll

extension=php_gettext.dll

extension=php_curl.dll

extension=php_exif.dll

extension=php_xmlrpc.dll

extension=php_openssl.dll

extension=php_soap.dll

extension=php_pdo_mysql.dll

extension=php_pdo_sqlite.dll

extension=php_imap.dll

extension=php_tidy.dll

extension=php_oci8_12c.dll

Any ideas how I get it working please?

Answers