Forum Stats

  • 3,839,773 Users
  • 2,262,535 Discussions
  • 7,901,053 Comments

Discussions

Problem connecting to Oracle 9i (9.2.0.1.0) using PHP on Windows IIS & SQL Server

user10684202
user10684202 Member Posts: 2
edited Aug 21, 2015 9:43PM in PHP

I'm trying to connect to our Oracle 9i (9.2.0.1.0) db using PHP run on Windows Server, IIS & SQL Server and I get the following error when using the oci_connect() command:

PHP Fatal error:  Call to undefined function oci_connect() in C:\inetpub\drupal7\www\bomquery.php on line 13

It is an intranet server setup to use Drupal 7.38.

Windows Server 2008 R2 Datacenter Edition (64-bit server)

IIS 7.5 (comes with Server 2008 R2)

SQL Server 2014 Express

PHP 5.6.12

The php extension (php_oci8.dll) didn't come with PHP 5.6.12 so I added the dll manually and then added and enabled the extension to php.ini.

Downloaded and used php_oci8.dll from: http://pecl.php.net/package/oci8

Downloaded and extracted Oracle Instantclient 11.2.0.1.0 to C:\Windows\SysWOW64\instantclient_11_2

Pointed System Properties -> Environment Variables -> PATH to %windir%\SysWOW64\instantclient_11_2

Any suggestions would be grateful. If the issue is resolved, I'll post a tutorial since I've been struggling for the past while to get it to work and it's super difficult finding any resources online that can help with this.

Answers

This discussion has been closed.