0

We have got a website that has been written in PHP (Wordpress) It is running on a VPS that has got the DB2 module installed. But we are unable to get the website connecting with the DB2 database that is on the I5 (AS400) server to be able to preform SQL statements. Currently the website we have got that is connected is in .asp and the person who did all that is no longer here.

I came across this article Connect PHP to AS400 with ODBC or DB2 Which is a bit of a help. But does anyone have some instuctions or step by step information about setting this up on the I5 (AS400) server and the website on the webserver. I have come across a IBM product call DB2 connect is this what I need.

Thanks

Community
  • 1
  • 1
Scott R
  • 1
  • 1
  • Hi Are you saying to install IBM i Access for Windows on to the Webserver? – Scott R May 27 '15 at 00:06
  • I have IBM i Access for Windows installed on my PC that I connect to my Iseries now and use the emulator to connect from my PC to my ISeries – Scott R May 27 '15 at 00:07
  • I want to be able to connect from the VPS webserver (my website in PHP wordpress ) to the As400 DB2 database. – Scott R May 27 '15 at 02:49
  • Yes. Install Client Access on the VPS web server. You don't need the full install; only the ODBC drivers. – Buck Calabro May 27 '15 at 13:50
  • I assume the VPS is using a Windows-based operating system? The instructions Buck has given you will work fine for Windows but it's different for Linux. – Benny Hill May 28 '15 at 00:38

1 Answers1

1

There are 3 versions of DB2: DB2 for Linux, Unix, Windows; DB2 for Z (mainframe); DB2 for IBM i. The machine you are calling i5 or AS/400 is running the IBM i operating system. The typical DB2 ODBC driver is probably for DB2 LUW. You want toe ODBC drivers for IBM i. These come with the product called IBM i Access for Windows. In earlier years, it was called Client Access for Windows.

The installer is on a DVD. The installation image is also on the IBM i server.

  • Map a network drive to QIBM\ProdData\Access\Windows on your IBM i.
  • Double-click cwblaunch.exe
  • Use the wizard to complete the install.

You can select to install only the ODBC driver by choosing 'Custom' install.

Buck Calabro
  • 7,558
  • 22
  • 25