[PHP-DEV] PHP 4.0 Bug #5814 Updated: ODBC connection to Oracle fails From: Bug Database (php-dev <email protected>)
Date: 07/28/00

ID: 5814
User Update by: fsegtrop <email protected>
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 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>