<div>
Super Awesome. It worked. Thanks again.
</div>


<div>
<div class="content wysiwyg-content">
I thought I had this problem solved:<br />
<a href="https://www.experts-exchange.com/questions/25957691/I-want-to-use-Linux-to-query-a-database-running-on-an-iSeries-server.html" rel="ugc">https://www.experts-exchange.com/questions/25957691/I-want-to-use-Linux-to-query-a-database-running-on-an-iSeries-server.html</a><br />
<br />
I have the iSeries Access for Linux installed on my desktop Ubuntu box and I can query the iSeries from command line using isql to the DSN I set up using ODBCConfig. My desktop Ubuntu has Apache and PHP installed, but no ODBC support. I want my Ubuntu Server (with ODBC support in Apache/PHP) to connect and serve up the webpages, so I went through the same installation steps (downloaded iSeries Access, used Alien to convert the rpm to a dpkg, installed, set up the odbc.ini and odbcinst.ini) but every time i try to start the isql to test the connection, i get an error: <br />
<br />
@linuxserver:~$ isql -v iseriesdb<br />
[01000][unixODBC][Driver Manager] Can't open lib '/opt/ibm/iSeries/Access/l<wbr />ib/libcwbo<wbr />dbc.so' : file not found<br />
[ISQL]ERROR: Could not SQLConnect<br />
<br />
The exact same command works fine on my desktop box. I have verified that the files exist in the right location. I've even tried it with sudo and by chmod'ing the files for all permissions, but same error. I'm stuck. What am I missing?<br />
<br />
Thanks.<br />

</div>
</div>


I thought I had this problem solved:
http://www.experts-exchange.com/OS/AS_-_400/Q_25957691.html

I have the iSeries Access for Linux installed on my desktop Ubuntu box and I can query the iSeries from command line using isql to the DSN I set up using ODBCConfig. My desktop Ubuntu has Apache and PHP installed, but no ODBC support. I want my Ubuntu Server (with ODBC support in Apache/PHP) to connect and serve up the webpages, so I went through the same installation steps (downloaded iSeries Access, used Alien to convert the rpm to a dpkg, installed, set up the odbc.ini and odbcinst.ini) but every time i try to start the isql to test the connection, i get an error: 

@linuxserver:~$ isql -v iseriesdb
[01000][unixODBC][Driver Manager] Can't open lib '/opt/ibm/iSeries/Access/lib/libcwbodbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect

The exact same command works fine on my desktop box. I have verified that the files exist in the right location. I've even tried it with sudo and by chmod'ing the files for all permissions, but same error. I'm stuck. What am I missing?

Thanks.


Connecting Ubuntu Server to IBM iSeries using ODBC

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

A Linux distribution is an operating system made as a software collection based on the Linux kernel and, often, on a package management system and are available for a variety of systems. A typical Linux distribution comprises a Linux kernel, GNU tools and libraries, additional software, documentation, a window system (the most common being the X Window System), a window manager, and a desktop environment. Most Linux systems are open-source software made available both as compiled binaries and in source code form, allowing modifications to the original software. Over three hundred distributions are in active development, including commercially backed distributions (such as Fedora, openSUSE and Ubuntu) and community-driven distributions (such as Debian, Slackware, Gentoo and Arch Linux).

Linux Distributions

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.