RE: [PHP-DB] PHP4 + ODBC Openlink +ORACLE 8.1 on DIGITAL

Hi Christian, Could you please open a support case at www.openlinksw.com/support/suppindx.htm? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Javalina [mailto:javalina@entelchile.net] > Sent: Friday, January 04, 2002 10:42 AM > To: php-db@lists.php.net > Subject: [PHP-DB] PHP4 + ODBC Openlink +ORACLE 8.1 on DIGITAL > > > 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 insecure@192.168.99.106.www_sv > oplrqb: unmap insecure@192.168.99.106.www_sv > 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 insecure@192.168.99.106. > oplrqb: aborted insecure@192.168.99.106. > 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/pr > oduct/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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >