| Need help in connecting Oracle with PHP Code [message #377066] |
Fri, 19 December 2008 15:09  |
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 #377401 is a reply to message #377087] |
Mon, 22 December 2008 14:46  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
