DB2 - PHP - AS400

[Anon]

First, Does anyone know how to get a complete Table listing on a AS400 which is being accessed via DB2 Connect/PHP/Apache? Ideally, I would like to find, or build, an application like phpMyAdmin to work with the database/tables on the AS400. Does anyone know of any solutions?

Second, I now have some valuable experience getting an AS400 system behind a firewall to work with a remote hosted webserver in realtime. So if anyone has any questions about this daunting process I will be glad to help where I can.

Thanks

[karlprinz]

We have installed Redhat 7.1
and the Korn shell with rpm
after adapting the pathes with softlinks we´ve installed successfully the IBM DB2Connect Personal Edition for Linux
compiled the newest stable version of PHP with "./configure --without-mysql --with-ibm-db2[=DIR]"

additionally we created and edited the .odbc.ini file in the home directory of the user /home/root:
[IBMDB2]
Driver=/usr/IBMdb2/V7.1/lib/libdb2.so
Description=SAMPLE DB2 ODBC Database
Host = <ip address>
ServerType = DB2
FetchBuffersize = 60
Database = <DB name>
UserName = <user name>
Password = <password>

and edited the obcinst.ini file

[IBMDB2]
Driver=/usr/IBMdb2/V7.1/lib/libdb2.so

The connection to the remote Database with:
$Link_ID=odbc_connect($dsn,$user,$password);
$Query_ID = odbc_do($Link_ID,"SELECT * FROM PMNTESTDTA.KASTAM");
$i=1;
$res=odbc_fetch_row($Query_ID,$i);
while($res)
{
print("A:".odbc_result($Query_ID,"a")." B:".odbc_result
($Query_ID,"b")."");
$res=odbc_fetch_row($Query_ID,$i);
}
odbc_free_result($Query_ID );
odbc_Close($Link_ID);

didn´t work, so I am asking what the hell is wrong with me, IBM or the DB2??

Thanks for hints how to solve this problem

Karl Prinz

[Anon]

First question - did you test the DB2 client - were you able to connect to your database with it and do a query?

Second - Im not sure where you were getting your installation "directions" - but it seems you have missed several important steps - the very BEST installation guide I have found is at: http://www.e-gineer.com/instructions/installing-ibm-db2-for-php4x-with-apache13x-on-linux.phtml

If you follow it exactly - you should not have any problems.

Also - I never had to modifiy any *.ini files

Also - It may just be coincidence, but I was never able to get a successful compile --without-mysql - so even if you dont plan on using it, it probably wont hurt to install it.

-Ken

[Anon]

Hi,

you should normally put the odbc.ini file in the home directory of the user running apache to take effect ...

Regards

[Anon]

Thanx for the installation guide,

the instructions I´ve posted were from a IBM-Forum, but I´ve got the whole @!#$ running with a little help from the IBM support.

thank you anyway
Karl

[Anon]

Thank you,

it was not the odbc.ini, it was a wrong CATALOG entry, the IBM support told me after several calls.

Karl