Remote Oracle Connection using PHP (Windows)

PHP
1

Hi,
I want to connect Oracle Db using oci_* functions.
I tried to enable the Oracle extension by uncommenting: extension=php_oci8.dll line from php.ini
and restarting Apache server. But that didn’t work.
Looking at Apache Server Log file ‘error.log’ gave me the following errors:
“PHP Warning: PHP Startup: Unable to load dynamic library ‘C:\\php\\ext\\php_oci8.dll’ - The specified module could not be found.\r
in Unknown on line 0”
But php_oci8.dll file is there is the mentioned dir.

Can anyone guide me where did i go wrong? or
How to enable Oracle extension in localhost (Windows)?

Thanks in advance for any help.

2

I’d start at http://www.oracle-base.com/articles/misc/apache-php-install-on-windows.php

If those steps don’t do it, let me know and I’ll see if I can dig up any more resources.

3

Hi cpardio,

Thanks for your willingness to help but unfortunately that didn’t work for me.
Actually i did the same thing previously. Not sure if we need to install some Oracle client kind of software in windows?

Thanks

4

Assuming your Oracle DB is located on a remote server (or not locally), it seems you need the Instant Client.
http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html

5

Hi,

I installed php , apache ,oracle and Instant Client Package in windows 7 as its provided in this link – http://www.oracle.com/technetwork/ar...nt-084410.html .
its working fine in localhost .
m trying to connect to remote database and getting this error ( oci_connect(): ORA-12546: TNS permission denied ) help me .

6

To connect to any database server remotely, it must be configured to allow remote connections.