|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2004-04-16 11:52 UTC] kalowsky@php.net
[2004-04-23 17:42 UTC] iliaa@php.net
[2004-05-19 11:12 UTC] thomas dot pataki at vonessenbank dot de
[2005-01-18 16:54 UTC] tony2001@php.net
[2005-01-26 01:00 UTC] php-bugs at lists dot php dot net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Mon Oct 27 02:00:01 2025 UTC |
Description: ------------ Hello, we used 4.3.4 with unixODBC Support compiled in(we use unixODBC 2.2.8), php was compiled as a module ./configure \ --with-apxs=/usr/local/apache/bin/apxs \ --with-unixODBC=/usr/local/unixODBC \ --with-mysql=/usr/local/mysql/4.0.16 \ --with-zlib \ --with-ftp \ --with-gd \ --with-jpeg-dir=/usr/lib \ --enable-versioning \ --enable-track-vars=yes \ --enable-url-includes \ --enable-sysvshm=yes \ --enable-sysvsem=yes \ --with-config-file-path=/etc Until 4.3.4 everything ist working fine, but after upgrade to 4.3.5 or even the newest 4.3.6 the connection to the DB (IBM DB2) fails with this error: [nativecode=S1000 [unixODBC][IBM][iSeries Access ODBC Driver]Missing system name needed for connection.] ** odbc://xxxx:xxxx@as400/ctbessen DB Error: connect failed the php code of this is the following: <?php putenv("ODBCINI=/etc/odbc.ini"); // muss sein require_once 'DB.php'; $user = 'xxxxx'; $pass = 'xxxxx'; $host = 'as400'; // DSN, nicht Hostname (der steht in odbc.ini)! $db_name = 'ctbessen'; $dsn = "odbc://$user:$pass@$host/$db_name"; $db = DB::connect($dsn, true); if (DB::isError($db)) { echo $db->getDebugInfo()."<br>"; die ($db->getMessage()); } $sql = "SELECT * FROM xxxx.xxxx.xxxx WHERE xxxx = xxxx"; // AS400.database.table $rs = $db->query($sql); while ($row = $rs->fetchRow()) { print $row[1]." "; print $row[2]." "; print $row[11]."<br>"; } $db->disconnect(); ?> if I downgrade to 4.3.4 everything is ok.... p.s. no changes to the php.ini (original from php.ini-dist) greetings Thomas