Access a oracle DB with PHP in win32 os

Anon

Hi people,

I've a PHP running in a Win/2000 and IIS. I need to access a Oracle database using PHP, but the original distribution downloaded at php.net don't have a ".dll" to make this. Someone know where can i find this one???

Tanks,
Fábio

Anon

go to http://www.php4win.de and take its distribution from there, it containt the dll that you're looking for, and others very usefulls.

dlls like: php_ora.dll, php_oci8.dll, php_ming.dll, and others.

I hope this is useful for you..

Jorge Aguilar

PD: Excuse me for my English, I'm from El Salvador and I speak Spanish.

[deleted]

Howdy!

I am having some trouble to get the oracle dll's working on NT4.0 server using php4.04 and php4.04pl1. Everytime when I enable the oracle extensions from php.ini and restart the server. I get a warning saying that

x:\path\to\extensions/php_oracle.dll

-The specified module could not be found.

And yes the '/' slash is shown instead of a backslash in the warning.

I have an application written in php3, which uses ODBC connection to database. When I ported the app to PHP4 (added the $HTTP*VARS[variable] things),the ODBC connection broke! Anyone got a solution to this?

Here is the error message that I get using PHP4:

SQL error: [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12154: TNS:could not resolve service name., SQL state S1000 in SQLConnect in d:\Inetpub\wwwroot\tbadesigner\dvkaisa\dvsearch.php on line 15

I still want to stress that I did not do any changes to database actions.

-ARi

Anon

Hi,

Your problem isn't with dll's!!! Do you configures the network service??? It's for identify the db name and other thinks about your DB. To configure the "network service" go into "Start"->"Prgrams"->"Oracle - OraHome81"->"Network Administration"->"Net8 Configuration Assistant" or edit the "tnsnames.ora" into "network\admin" directory. If you can't do this, send me a e-mail and I wil try help you!!!

Regards
Fábio

[deleted]

I am not sure that I got my point in my previous posts =)

There was two different scenarios. The first one was the problem with getting up the Oracle extensions and the second case was the ODBC - Oracle connection.

First I need to get the ODBC connection up and running and then it may be possible that I will switch from ODBC to native connection.

Thanks to everyone who is willing to help

-ARi

Anon

Ari,

For any way, you need to configure the network service. In ODBC connect and in native access you will need to informe the "service name" and it is configured in the "Network Administration" otherwise you don't will obtain a connection in PHP.

Fábio