DB2 problems
| From: | Mirko Nalesso | Date: | Tue, 11 Jul 2000 15:47:24 +0000 |
| Subject: | DB2 problems | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1041@lists.php.net to get a copy of this message | ||
This is the file odbc.php3:
-------------------------------------------------------------------
<?
putenv("DB2INSTANCE=db2inst1");
putenv("DB2DIR=/usr/IBMdb2/V6.1");
putenv("INSTHOME=/home/db2inst1");
$path_current = getenv("PATH");
putenv("PATH=$path_current:/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/home/db2inst1/sqllib/misc:.");
$ldlibrary = getenv("LD_LIBRARY_PATH");
putenv("LD_LIBRARY_PATH=$ldlibrary:/home/db2inst1/sqllib/lib");
putenv("ODBC.INI=/home/db2inst1/htdocs/odbc.ini");
$enviro = getenv("PATH");
echo "\n".$enviro."\n";
$enviro = getenv("DB2INSTANCE");
echo "\n".$enviro."\n";
$enviro = getenv("DB2DIR");
echo "\n".$enviro."\n";
$enviro = getenv("INSTHOME");
echo "\n".$enviro."\n";
$enviro = getenv("PATH");
echo "\n".$enviro."\n";
$enviro = getenv("LD_LIBRARY_PATH");
echo "\n".$enviro."\n";
$select = "SELECT REGION ";
$from = "FROM SALES ";
$DB2INSTANCE='db2inst1';
$c = odbc_pconnect('sample','db2inst1','!dIBMb?',SQL_CUR_DEFAULT);
if ($c > 0) {
$query = $select . $from;
$res = odbc_exec($c, $query);
$nc=odbc_num_fields($res);
$nr=odbc_num_rows($res);
echo "\nNumero tuple: $nr\n\n";
$buf = array();
for ($i = 1;$i <= $nr;$i++) {
$cols = odbc_fetch_into($res, &$buf);
echo "$i: $buf[0]\n";
}
/* Free all resources and close connection */
odbc_free_result($res);
odbc_close($c);
} else {
echo "BAD CONNECTION Number $c \n";
echo "--> $php_errormsg \n";
}
?>
---------------------------------------------------------------
If I write on a shell "php odbc.php3", there is the connection to
database sample and right results appear. But if open a Netscape and
open location "http://localhost.localdomain/odbc.php3"
the results are:
--------------------------------------------------------------------
/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin
db2inst1 /usr/IBMdb2/V6.1 /home/db2inst1
/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin:/root/bin
/home/db2inst1/sqllib/lib
Warning: SQL error: üçÿ¿ çÿ¿@?ÿÿÿÿÁ¨E@ö^~@Ð?z@, SQL state
P°-@@Pèÿ¿8 P°-@ in SQLConnect in /home/db2inst1/htdocs/odbc.php3 on
line 37
BAD CONNECTION Number -->
--------------------------------------------------------------------
My problem is: why does it work on shell and not on Netscape?
Where can I find db2.o?
Always thanks a lot. Mirko