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

user10684202

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.

Sdhamoth-Oracle

Connections between 10.2 (or higher) and 9.2.0.1, 9.2.0.2 or 9.2.0.3 was never certified or supported. So connecting to DB running  on 9.2.0.1 using client 11.2.0.1 could face lot of issue. Please refer support Doc 207303.1 to know the Client/Server interoperability.

user10684202

@Sdhamoth-Oracle, I'm unable to refer to that website as I don't have a Support Identifier.

I have access to the Oracle server (Windows Server 2003) though. Would I be able to use anything from the server to replace instantclient_11_2?

Sdhamoth-Oracle

If the DB is running on 9.2.0.4, then PHP 5.6/OCI8 2.X/InstantClient 11.2.0.1 combination may work. I haven't tried this combination before.

Christopher Jones-Oracle

The immediate problem doesn't seem to be about Oracle version support, it is about getting the IIS environment configured to allow the OCI8 extension DLL to be loaded. Until someone who uses Windows and IIS gives me more info, everything I know is here: https://blogs.oracle.com/opal/entry/how_to_use_iis_php_and_oracle

I wouldn't try to use the OCI8 extension to connect to SQL Server, but you probably know that.