The locations for odbcinst. Leave a Reply Cancel reply Enter your comment here I have the unixODBC installed as well. Edit the files, the odbcinst. Note that registered members see fewer ads, and ContentLink is completely disabled once you log in. IBM i developers generally consider it best practice to use the library list similar to a path.

Uploader: Voodookree
Date Added: 2 January 2008
File Size: 39.87 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 26549
Price: Free* [*Free Regsitration Required]

Find More Posts by denniswilliams.

To see the true error we need to use ldd to see the linked dependancies of libcwdodbc. Fill in your details below or click an icon to log in: The next stage was to use php to link to this odbc.

A linuz of assumptions must be made: If there are any important errors, you must troubleshoot the iSeries and Linux connectivity.

Thanks for the reply, I had installed iSeriesAccess But because osbc driver is based on the Client Access ODBC Driver for Windows, it already takes advantage of the performance improvements that have been added to that driver through the years. Post as a guest Name.

ODBC from Linux to iseries (AS400) for php

Entering “cwbping” and specifying the iSeries name should provide results like those shown in Figure 6. Details are available online.


Test the connection using the commandline isql and the DSN. Your command may be different depending on the shell you’re using, but you essentially want to set environment variable QTDIR to the location of your Qt libraries, which are usually installed as part of a Linux server setup.

Notify me of new comments via email. It doesn’t seem to be the case. I have the unixODBC accexs as well.

You could use a command such as: Notice that the naming convention is standard SQL; in other words, the collection and table name are separated by a period. Contact IBM technical support to rectify the issue. You are commenting using your Facebook account. DefaultLibrariesDatabaseand DefaultPkgLibrary can be specified as required or left blank and specified higher in the php, I only use the DefaultLibraries.

The first step in this download process, which may be unnecessary as many distributions already ship the driver manager, is to access the unixODBC Web site. Internal error while loading xml4c library.

Join our community today! I used a system DSN, which can be used by a user. Figure 7 illustrates the use of the “isql MyiSeries userid password” command. The screen is shown in Figure 3.

ODBC driver for Linux

A simple application that can Select, Update, Insert or Delete rows from an iSeries table and synchronize the data with a Linux database can be written. The only difference between the odbcinst. This example assumes the application requiring ODBC connectivity will be run with the userid “db2inst1” and will connect to: But once you have this up and running, I think you’ll like it.


Introduction to Linux – A Hands on Guide This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features.

When the file is unzipped and untard, you must create the driver manager. I lihux to connect using PDO, but the error message I got was that the iserjes. Your configuration may have only accesa iSeries driver registered.