Re: ZendStudio i5 on Linux access DB2 on iSeries

I suppose you could use the PHP-Java bridge:
http://php-java-bridge.sourceforge.net/pjb/
PHP scripts could call Toolbox for Java classes to remotely access the
AS400.

In theory, anyway.

And the question at that point becomes: why use PHP? If you have to run
a servlet engine for the PHP-Java bridge, why not just create servlets
that directly use the Toolbox for Java classes?

Kelly


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Mike Cunningham
Sent: Monday, October 19, 2009 11:46 AM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] ZendStudio i5 on Linux access DB2 on iSeries

I just asked a similar question on the midrange list. We want to access
DB2 on i from linux also but in our case it's from an perl app but the
ODBC/OLE DB driver should be the same.

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx]
On Behalf Of Aaron Bartell
Sent: Monday, October 19, 2009 11:21 AM
To: Web Enabling the AS400 / iSeries
Subject: [WEB400] ZendStudio i5 on Linux access DB2 on iSeries

Heyo,

I am racking my brains this morning. I am developing a simple PHP
script
that displays the results of a SQL SELECT statement back to the browser.
I
should note that developing this script, and configuring an ODBC
connection
to DB2/400, on Windows is working just fine. But I am now trying to get
ZendStudio/PHP on my Ubuntu Linux desktop to communicate with DB2 on the
iSeries. I was heading down the unixodbc.org path until I remembered
there
was the i5 PHP toolkit. I have since been trying to make the following
simple script run successfully:

<?php

include_once('Toolkit_classes.php');

i5_connect ( '999.999.999.999', 'USER', 'PASSWORD' );

if (! $conn)
die ( "Connection error is :" . i5_errormsg () );
else
echo "Connection OK! " . $conn . "<br>\n";

?>

I thought I heard mention that the toolkit came with the i5 version of
ZendStudio but now I am wondering if it is instead a component of
ZendCore.
The issue with the above is it can't resolve the i5_* PHP API's and I
can't
seem to find them anywhere on my system either.

Anybody else running their PHP on Linux and communicating with DB2 on
the
iSeries? I am open to pretty much any options at this point. No, it
isn't
an option to run the PHP on the iSeries - client requirement.

Thanks,
Aaron Bartell
http://mowyourlawn.com