Hi, I don't read this often so please reply to my email:
rob@vendorpromotions.com
I'm using PHP 4.3.1 with DB2 8.1 on RedHat 8.0. I compiled against DB2
fine, with no problems. I connect using db2 with no problems - the 'test'
database is perfectly catalogued.
However when I try to run the below page I get this error back in response:
Warning: SQL error: 5¥B¤6-ATR, SQL state dÓÿ¿þÿ in SQLConnect in
/home/mhill/vendorpro_staging_area/testing/db2_connect_test.php on line 3
no connect
or basically a bunch of garbage. I note that someone in V6.1 got it to work
by installing db2 connect, however that's /already/ installed.
If I keep running the test it changes the garbage only slightly, and after a
while it just gives this:
Warning: SQL error: [IBM][CLI Driver] SQLSTATE=58004, SQL state 58004 in
SQLConnect in
/home/mhill/vendorpro_staging_area/testing/db2_connect_test.php on line 3
no connect
I'm at a loss here. Obviously this is some sort of serious linking or
protocol issue or something, but huh? Maybe it's been fixed in 4.3.2, but
it's not in the change log if that's so.
Has anyone found a solution to this problem? It does seem to occur
/somewhat/ regularly. I haven't tried the IBM fixpacks yet, that will be
occurring shortly. However I reports from someone I work with that this
still happens.
There are warnings of pointers being cast to integers during the compile.
Who's got db2 actually /working/?
<?php
$conn = odbc_connect("test", "db2", "pw");
if(!$conn) die("no connect");
$query = odbc_exec($conn, "select * from syscat.tables");
odbc_result_all($query);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<p>DB2 connect page</p>
<pre><?php print_r($_ENV) ?></pre>
</body>
</html>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
