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]

Reply via email to