php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #10992 Problem connecting to Oracle
Submitted: 2001-05-21 12:56 UTC Modified: 2001-06-06 18:38 UTC
From: fabio dot pascarella at iol dot it Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.5 OS: Windows
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2001-05-21 12:56 UTC] fabio dot pascarella at iol dot it 
On Windows NT 4 and IIS PHP, from version 4 to the latest, is encountering a problem connecting remote Oracle using ODBC. When tring to connect to a DB using the alias defined in the file TNSNAMES.ORA also Oracle and OCI8 functions are doing the same.

The problem is that, when using Oracle client version 7.3.4, the file SQLNET.ORA needs to be saved in Unix text format to get a connection to a DB defined in TNSNAMES.ORA, which needs to be saved the same way to get connected when using Oracle client 8.

I know it is not a severe bug, but if you look at the bug reporting and in many PHP mailing lists you'll find a lot of people reporting problems connecting to Oracle from PHP on Windows, at the risk of lowering the trust in the use of PHP in commercial or enterprise applications.

Please fix it ASAP.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-30 11:53 UTC] kalowsky@php.net 
considering PHP never actually opens up either of this files, it sounds like an issue with Oracle more than an issue with PHP.  the PHP/ODBC uses external libraries to create the odbc connections. 

The best I can offer now is to put a mention on the odbc_connect page about the fix.
 [2001-06-04 17:21 UTC] fabio dot pascarella at iol dot it 
"to put a mention on the odbc_connect page" because "it sounds like an issue with Oracle more than an issue with PHP" is a generous offer, but it seems like making the Windows section of the "Bug Reporting" useless.

I mean that if you want to say it's an Oracle issue, than please explain me why Oracle ODBC never fails (on same machine, OS, environment) but when called by PHP4.  
PHP3 is working too, but nothing to do from the first version 4 to the latest. 

Something is telling me that this problem may be related to the use of the new Zend core in PHP4, but i'm sure you'll explain me i'm wrong and will help to spot the nature of the problem, because we all are tired of seeing PHP going to get trashed by IIS/ASP lovers. 

"the PHP/ODBC uses external libraries"... The names, we want the names (of the libraries)... 
If the logic has to be -fix it yourself- it's ok to me, but tring to provide some help to fix it, instead of closing the bug asap just like a federal (or Micr*soft) employee could do, would show the kind of interest in PHP that is expected from the php.net staff.
 [2001-06-06 18:38 UTC] kalowsky@php.net 
External libraries that PHP uses on windows:
ODBC32.dll

I don't know why PHP 3 works and PHP 4 doesn't, and nor do any of the Oracle developers I have asked.  Zend does not open the sqlnet, or tnsnames files ever so I have no reason to believe it is at fault.  

In the future keep your bug reports to facts and not to the rhetoric you are spewing forth.  It does not advance your point or case any, only hurts it (in my view).
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Wed Apr 24 05:01:30 2024 UTC