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

From: michael_d_gaudette@groton.pfizer.com Operating system: NT 4 (SP4) PHP version: 4.0.2 PHP Bug Type: ODBC related Bug description: Can not resolve TNS NAMES with ORALCE connection 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 files\apache group\apache\htdocs\bdm\timedist\checkusername.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.