Scott R
Scott R

Reputation: 1

Connecting a DB2 database from a Webserver in PHP Wordpress

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

Upvotes: 0

Views: 1069

Answers (1)

Buck Calabro
Buck Calabro

Reputation: 7633

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.

Upvotes: 1

Related Questions