Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user10684202Aug 18 2015 — edited Aug 21 2015

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 18 2015
Added on Aug 18 2015
4 comments
2,460 views