PHP 4.0 Bug #5814 Updated: ODBC connection to Oracle fails

ID: 5814 User Update by: fsegtrop@estiem.org Status: Feedback Bug Type: ODBC related Description: ODBC connection to Oracle fails No, both php3 and php4 run as CGI, and with the same user. Also, everyone has full access to the tnsnames.ora. I have configured Apache the way that scripts ending with .php4 are executed by php4 and scripts ending with .php3 by php3. A script, run as "test.php4" fails, the same run as "test.php3" succeeds. Everything runs as CGI, not as Apache module. I have written a small test-program with C, and there the connection using SQLConnect works, as well as with php3. Somehow, in php4 the same function call (SQLConnect) returns SQL_ERROR. In php3 and my test-program, SQLConnect finds the missing parameters DBQ and ASY from the ODBC-driver and can resolve the DBQ setting, in php4 it also finds the DBQ and ASY parameters, but cannot resolve the DBQ, though there is no obvious difference in the environment (same users, same machine, same browser). Anyhow, the php_odbc.c source does not show me any hint why this behaviour occurs, and it appears to be a different environment, but then the same occurs on different machines. Always, php3 works, php4 does not work, other ODBC-clients work. One idea is: in php3, the SQLConnect runs from the exe, in php4 from a dll (even in the CGI-version), and the TNS-resolution does not work there? That's the only difference I have found so far. If i Find more, I'll update this report. Best regards, Frank Full Bug description available at: http://bugs.php.net/?id=5814