Connecting Ubuntu Server to IBM iSeries using ODBC

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.
leviatdrAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

medveddCommented:
Add the path /opt/ibm/iSeries/Access/lib to the file "/etc/ld.so.conf" and execute "sudo ldconfig" once.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
leviatdrAuthor Commented:
Super Awesome. It worked. Thanks again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.