AS/400 DB2 Connection Problems

[Anon]

I know there have been a million db2 questions on this site, but I have read all the threads and haven't found a solution.

I am trying to get a php script running on a win2k/iis machine to connect to an AS/400 DB2 database.

I setup the DSN in the control panel in win2k. We have another program called "Client Access" that installs ODBC drivers for the IBM, so I used that.

My script does something like this:

echo 'start';
$connection = odbc_connect('AS400','','') or die('could not connect');
echo 'end';

When I run the script it just hangs until IIS times it out. If I change "AS400" to something else, I get an error right away.

Anybody have any idea why the script would be hanging forver?

[Anon]

Turns out the ODBC driver I was using was missing a service pack [I hate the M$ world]. The old ODBC driver had a bug in it where it would "double prompt" for a login and password, thus causing the script to time out.

PHP on IIS connects to a DB2 database on an AS/400 and queries a table...but man, is it slow!