Skip to Main Content
Forums

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

John JB Brock-Oracle

Details please.
What version of JET?
What do you mean by "move the chart months and weeks"? How are you doing that moving?

Thanks

renangi

version 9.2.0, yes, after loading the chart, when we move the chart months and weeks.,
I have search popup, it will display all the projects, when i select one project, showing chart and values.. after loading the chart when i move the chart..
for the next project when i select from search popup, chart not displaying.

John JB Brock-Oracle

Please describe in more detail, what this means, "after loading the chart when i move the chart.."
What steps are you taking to "move the chart". I can't tell what exactly you are doing from the information you have provided. Without that info, I can't try and create a local reproduction case.

Wilson Louie-Oracle

Any screenshots and/or videos and/or code demonstrating the issue would be helpful. Thanks!

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

Post Details

Locked on Sep 18 2015
Added on Aug 18 2015
#php
4 comments
2,463 views