Home » Open Source » Programming Interfaces » Need help in connecting Oracle with PHP Code (PHP 5.2 php_oci8.dll)
Need help in connecting Oracle with PHP Code [message #377066] Fri, 19 December 2008 15:09 Go to next message
neal.pressley
Messages: 9
Registered: December 2008
Junior Member
Need help in connecting Oracle with PHP Code


Hello,
I am trying to connect Oracle 10 g thru php code. I have IIS on windows 2003 and PHP 5.2.6 installed on the computer and thier extensions for connectiing to MYSQL database. I went thru the tutorials and accordingly installed Oracle client (9.2) on my machine.I configured SQL Net and connect to Oracle.

However, I do not see the files php_oci8.dll anywhere which is needed. The tutorial does not clearly say how one gets this file, as part of installation of PHP or as part of installation of Oracle client.

Anyway, I downloaded that dll from internet and kept at the right place and updated the php.ini file to use the right oracle extenion instead of earlier mysql extension. but now it gives me an error messge that it can not find php4ts.dll.


Some other tutorial suggested to use "Oracle Database Instant Client", I installed that also but that too does not have the file php_oci8.dll

What is the right way to get php_oci8.dll?
Neal

[Updated on: Fri, 19 December 2008 15:47]

Report message to a moderator

Re: Need help in connecting Oracle with PHP Code [message #377070 is a reply to message #377066] Fri, 19 December 2008 16:50 Go to previous messageGo to next message
neal.pressley
Messages: 9
Registered: December 2008
Junior Member
Please ignore the above query.

I followed the steps at
http://www.oracle.com/technology/pub/notes/technote_php_instant.html
and I could configure php_oci8.dll.

Actually I was missing "PHP binary zip file "

Neal
Re: Need help in connecting Oracle with PHP Code [message #377087 is a reply to message #377070] Sat, 20 December 2008 01:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback and the link.

Regards
Michel
Re: Need help in connecting Oracle with PHP Code [message #377401 is a reply to message #377087] Mon, 22 December 2008 14:46 Go to previous messageGo to next message
neal.pressley
Messages: 9
Registered: December 2008
Junior Member
Hi,

Today morning due to some reason, I reinstalled Oracle Client 9.2 and after that my earlier configuration is not working.
Details are here.
I have windows 2003 , IIS and PHP 5.2. I have installed "Oracle Instant Client - instantclient-basic-win32-10.2.0.3-20061115 " also as mentioned on the above link.
Added the path of Instant Client along in the PATH variable and then also copied tnasnames.ora in the folder of instant client and then added the TNS_ADMIN.


When I run in test.php, I see that Oci8s support is enabled. but when I use, the command oci_connect, I get following error message.

"ORA-12154: TNS:could not resolve the connect identifier specified"

Is the problem due to Oracle Client 9.2 as well as Oracle instant client installed together in the machine. I need to setup a system DSN to Oracle . Do I need Oracle client 9.2 or I can deinstall it?

Please help. Neal
Re: Need help in connecting Oracle with PHP Code [message #377408 is a reply to message #377401] Mon, 22 December 2008 16:54 Go to previous messageGo to next message
neal.pressley
Messages: 9
Registered: December 2008
Junior Member
Please ignore the query again, I got rid of Oracle 9.2 client and Oracle instant client and Installed Oracle 10.2 client and everything is fine now. (My server is Oracle 10.2 and so using Oracle 10.2 client makes sense too.)
Re: Need help in connecting Oracle with PHP Code [message #377437 is a reply to message #377408] Tue, 23 December 2008 01:20 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Thanks for the feedback.
Previous Topic: linking oracle 9idb to ms access
Next Topic: Question regarding OLE2....
Goto Forum:
  


Current Time: Fri Mar 29 00:29:51 CDT 2024