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

ID: 6936 Updated by: kalowsky Reported By: michael_d_gaudette@groton.pfizer.com Old-Status: Feedback Status: Closed Bug Type: ODBC related PHP Version: 4.0.2 Assigned To: Comments: no user feedback, considered fixed in current cvs. if this is untrue, please re-open the bug. Previous Comments: --------------------------------------------------------------------------- [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. --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=6936&edit=2