Pb with PHP4.0.4 as CGI, OCI8, WinNT
| From: | Benoit Noss | Date: | Thu, 04 Jan 2001 10:53:17 +0000 |
| Subject: | Pb with PHP4.0.4 as CGI, OCI8, WinNT | ||
| Groups: | php.db php.install php.windows | ||
| Request: | Send a blank email to php-db+get-5589@lists.php.net to get a copy of this message | ||
Hello,
I am working with php4.0.4 downloaded from php4win.de (php4_0_4-win32-20001210.zip).
My OS is WinNT SP5
I have an Oracle Net8.0 client installed.
I had first PHP3 working with the following configuration (CGI, OCI8) everything was fine.
When I tried to upgrade to PHP4, all OCI8 related functions failed because of connection problems
(scripts that worked with PHP3), here the message (Warning: _oci_open_server: ORA-12154: TNS:could
not resolve service name in d:/iaurif80/dev/test/index.php on line 4).
The connection was fine with the SQL+ Net8.0 client with the same connection parameters.
Then I saved TNSNAMES.ORA as an UNIX file (it is a possibility in my text editor, end of lines are
different)
Then I tested again the PHP scripts : no more warnings, everything is working now
I have reproduced this experience on a blank NT server (it proves that the way of writing
tnsnames.ora causes PHP4 to work or not with Oracle).
I am not though enough to fix this little bug, but it can perhaps be useful for those who want to
improve OCI8.dll for a next PHP4 release
Bye
Benoit NOSS - (benoit.noss@iaurif.org) (Bureau 226)
IAURIF, Service MSI, 15 rue Falguiere, 75740 PARIS Cedex 15 FRANCE
Tel : (+33) 1 53 85 78 04 Fax : (+33) 1 53 85 76 36