php-db | 2001011

[PHP-DB] Pb with PHP4.0.4 as CGI, OCI8, WinNT From: Benoit Noss (Benoit.Noss <email protected>)
Date: 01/04/01

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 <email protected>) (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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>