here is what works for me assuming you have the capability to use the oci functions meaning you have that extension enabled in your php.ini then instead of the user name snad password and sid ect.. use the string in tnsnames.ora as your server and your normal user name and password so it would look something like this
ociplogon(username,password,$stringfromtnsnames) into a connection id ect.. and bingo let me know if this helps i can send some code examples if you need it took me hours to figure this out
Wayne Cope wrote:
Does anybody out there have PHP4 ISAPI module working with OCI8 on a Windows platform ?
I have two options:
- Get it working, by fair means or foul.
- Drop the use of PHP altogether and completely redevelop everything I've done over the past 3 months.
Guess which I'd prefer !!?
I have to use PHP4 because I need to use IIS4 which only runs PHP4 ISAPI module - it won't run the executable because of a problem on security. Problem is, PHP4 doesn't seem to work with Oracle (OCI8). I've downloaded some bits from swwwing.com and it loads now, but I constantly the error:
"ORA-12203: TNS:unable to connect to destination"
I can assure you that the user name and tnsnames etc. is correct - honest !!
When I look in the sql log file I see it's looking at BEQ not TCP - I guess this is why it's not finding what it's looking for - the Oracle server is not a local server.
Any help much appreciated....
Thanks !
Wayne Cope
