I want to create a production wamp Windows 7 Apache mysql PHP server but I need to get all my data from an AS400. What software or code do I need to connect to the AS400 that will allow me to access data via sql statements in realtime.
Software/Hardware used:
windows 7 php apache mysql as400 iseries db2
ASKED:
August 17, 2012 3:03 PM
run it all on the i and have an iAMP server
In general, you need the ODBC driver. You can install the iSeries Access drivers from your iSeries. Review the Setting up the PC topic in the Information Center. The ‘Install’ sub-topics cover details you’ll want. Any ‘NetServer’ references will possibly be useful to you also.
Without knowing what’s already been configured on your iSeries, it’s hard to know what actual steps you’ll take. Whoever manages your iSeries can give you whatever help is available.
One common setup allows you to use Windows Explorer to drill into the /QIBM directory on your iSeries and install ODBC from there.
Tom