iSeries AS400 ODBC driver for Ubuntu 6.06

Asked by Rupert

Hi guys ...

I am looking for an iSeries (AS400) ODBC driver for php 5 / Ubuntu ... I have tried to download the one form IBM's site - but it seems to have vannished.

I have also installed php5-ODBC from the Ubuntu packages list ... and also the Ubuntu GUI (convinced myself it would make life "easier" ... ya right! - I hear someone snigger ;) but can't seem to find a way to access any ODBC settings from either the GUI menus or the command line.

I used to use the iSeries driver provided by IBM on a Suse server - and simply used [ODBCConfig] to fire up the GUI setup for the ODBC connection ... however, that was years ago and I am clearly a little out of my depth here trying to upgrade my server to Ubuntu.

Can anyone please provide some assistance and / or some guidance with this ??

Thanx-a-lot ...
Rupert

UPDATE ...
I eventually found the iSeries driver from IBM in rpm format and used Alien to convert and install the driver ... however, I still can't get to an ODBC setup dialog as described above with the ODBCConfig command ...

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Alan Pope 🍺🐧🐱 🦄 (popey) said :
#1

Once the .deb has been created from the rpm and has been installed you can run the following command to see what files were installed by the deb.

dpkg -L <packagename>

The ODBCConfig command may actually be a different name - possibly in a different case as "odbcconfig" for example. I would scroll through that list looking for things that get placed in "bin" directories that have likely sounding names. Alternatively use tab completion to find it as follows:-

In a terminal type "ODBC" then press <tab> to see if it autocompletes the command. If nothing happens press <tab> again to get a list of commands that are in your path that start ODBC. Try again with "odbc" to see if there are commands starting with odbc.

If the GUI config command is indeed in that deb (from the original rpm) then you could run it to test it, and then create a shortcut to it from the panel or your desktop.

Hope that helps.

Can you help with this problem?

Provide an answer of your own, or ask Rupert for more information if necessary.

To post a message you must log in.