PHP 4.0 Bug #6936 Updated: Can not resolve TNS NAMES with ORALCE connection

ID: 6936 User Update by: michael_d_gaudette@groton.pfizer.com Old-Status: Closed Status: Open Bug Type: ODBC related Description: Can not resolve TNS NAMES with ORALCE connection not fixed Previous Comments: --------------------------------------------------------------------------- [2001-04-17 07:51:37] michael_d_gaudette@groton.pfizer.com Yes it is still happening. And I do not believe it is a configuration issue. Windows NT 4.0 service pack 4 / Apache 1.3 / PHP 4.0.4PL1 and PHP 3.0.6 I have two directories one call php306 with php.exe and associated files and one called php404pl1 with php.exe and associated files. When I point the ScriptAlias to php306 all my php applications and ODBC calls work perfect. If I go in and point it to php404pl1 (I copied the appropriate dll's to the proper directory and make sure to use the php.ini not php3.ini) all my code works fine except ODBC functions?? If I change it right back to php3 they work fine. I checked for compatibility issues of the functions and there appears to be none the error is "Can not resolve host name in tnsnames.ora" Well I did not move it and it works perfect for PHP3, Visual Basic, Visual C++, SAS and all other development platforms I work with. Any ideas because I have tried just about everything I can think of. Also I have encountered a lot of people who are having this exact problem and in talking with them sounds like they have tried every possible work around I have tried to no avail. Thanks, Mike --------------------------------------------------------------------------- [2001-04-16 23:08:24] kalowsky@php.net no user feedback, considered fixed in current cvs. if this is untrue, please re-open the bug. --------------------------------------------------------------------------- [2001-03-27 11:11:07] kalowsky@php.net this really REALLY sounds likea configuration bug on your end with oracle8i, and not a PHP issue at all. but regardless, is this A) still happening? B) if so can you provide any more information (config files, sample script, etc etc)? --------------------------------------------------------------------------- [2000-09-29 05:49:42] michael_d_gaudette@groton.pfizer.com error: Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:program filesapache groupapachehtdocsbdmtimedistcheckusername.phtml on line 3 I have seen this earlier in the bug list and Kara made a comment that the ODBC driver was not setup correctly. However, I know this to be not true in my case. I can get it to connect through ODBC to other databases but not oracle 8i with either microsoft ODBC for oracle or an oracle driver 8.00.0400. I works PERFECT if I change httpd.conf to point to PHP306. I have not touched the DSN configuration and it works perfect with php306. I change it to 402 restart apache and error! There is a real problem here and not a configuration issue. I have run against this with many many users on phpbuilder.com. Please help! Thank you very very much. --------------------------------------------------------------------------- Full Bug description available at: http://bugs.php.net/?id=6936