Hi to all...i have a problem when i try to connect from php to the oracle 8.1 on a DIGITAL ALPHA MAchine..
i did use openlink , when i try the connection with the SQL aplication test of the OPENLINK driver , function OK...the debug of this query is. oplrqb: 192.168.99.106 called (192.168.99.106.1201) oplrqb: request: domain=Oracle 8.1.x database= serveropts= oplrqb: connectopts= user=system opsys=unix readonly=0 oplrqb: application=www_sv processid=10770 oplrqb: solve mapping: ora81::insecure:other:192.168.99.106:www_sv:rw oplrqb: using mapping: ora81:*:*:*:*:*:* oplrqb: using [generic_ora81] ServerProgram=ora81_mv oplrqb: connect params: domain=Oracle 8.1.x db= serveropts= readonly=0 oplrqb: connectopts= user=system opsys=unix machine=192.168.99.106 application=www_sv oplrqb: spawning /usr/local/openlink/bin/ora81_mv generic_ora81 +debug oplrqb: asking agent for server handle oplrqb: setting Environment ORACLE81 oplrqb: change environment 'ORACLE_HOME' -> '/usr/OraHome1' oplrqb: change environment 'ORACLE_SID' -> 'Base3' oplrqb: change environment 'SHOW_REMARKS' -> 'N' oplrqb: change environment 'CURSOR_SENSITIVITY' -> 'LOW' oplrqb: change environment 'LD_LIBRARY_PATH' -> '/usr/OraHome1/lib' oplrqb: change environment 'LIBPATH' -> '/usr/OraHome1/lib' oplrqb: change environment 'SHLIB_PATH' -> '/usr/OraHome1/lib' generic_ora81: server starting oplrqb: got it! oplrqb: asking agent for connection handle oplrqb: got it! oplrqb: accepted [EMAIL PROTECTED] oplrqb: unmap [EMAIL PROTECTED] oplrqb: killing generic_ora81 agent (pid=4627) generic_ora81: got SIGTERM generic_ora81: server shutting down oplrqb: pid 4627 died with exit code 0 oplrqb: agent died (pid=4627) oplrqb: removing agent generic_ora81 with 0 connections the debug of the PHP4 query ,is oplrqb: 192.168.99.106 called (192.168.99.106.1199) oplrqb: request: domain=Oracle 8.1.x database= serveropts= oplrqb: connectopts= user=system opsys=unix readonly=0 oplrqb: application= processid=10751 oplrqb: solve mapping: ora81::insecure:other:192.168.99.106::rw oplrqb: using mapping: ora81:*:*:*:*:*:* oplrqb: using [generic_ora81] ServerProgram=ora81_mv oplrqb: connect params: domain=Oracle 8.1.x db= serveropts= readonly=0 oplrqb: connectopts= user=system opsys=unix machine=192.168.99.106 application= oplrqb: spawning /usr/local/openlink/bin/ora81_mv generic_ora81 +debug oplrqb: asking agent for server handle oplrqb: setting Environment ORACLE81 oplrqb: change environment 'ORACLE_HOME' -> '/usr/OraHome1' oplrqb: change environment 'ORACLE_SID' -> 'Base3' oplrqb: change environment 'SHOW_REMARKS' -> 'N' oplrqb: change environment 'CURSOR_SENSITIVITY' -> 'LOW' oplrqb: change environment 'LD_LIBRARY_PATH' -> '/usr/OraHome1/lib' oplrqb: change environment 'LIBPATH' -> '/usr/OraHome1/lib' oplrqb: change environment 'SHLIB_PATH' -> '/usr/OraHome1/lib' generic_ora81: server starting oplrqb: got it! oplrqb: asking agent for connection handle oplrqb: got it! oplrqb: accepted [EMAIL PROTECTED] oplrqb: aborted [EMAIL PROTECTED] generic_ora81: got SIGTERM generic_ora81: server shutting down oplrqb: pid 4616 died with exit code 0 oplrqb: agent died (pid=4616) oplrqb: removing agent generic_ora81 with 0 connections if you saww the only diference is when i try to connect with PHP don't send the www_sv option with the IP of request... the output of the PHP page is Warning: SQL error: [iODBC][Driver Manager]Connection in use, SQL state 08002 in SQLConnect in /usr/local/apache/htdocs/prueba_odbc.php on line 16 the line the is when i try to connect with this code. <? /* some environment variables, you can test to comment them out to see if things * still work. */ putenv("LD_LIBRARY_PATH=/usr/local/openlink/lib:/usr/app/oracle/product/8.1.7/lib"); putenv("UDBCINI=/usr/local/openlink/bin/udbc.ini"); putenv("ODBCINI=/usr/local/openlink/bin/odbc.ini"); putenv("DebugFile=/tmp/udbc.out"); // debug trace output $dsn="ORACLE"; // note 'DSN=' is required $user="system"; $password="Admtas"; $sql="select * from prueba519"; $conn_id=odbc_connect($dsn,$user,$password); odbc_close($conn_id); ?> thsnk's to all. Cristian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]