title: Unable to connect to iSeries odbc
body: <p>I've spent a lot of hours trying to figure this out. So maybe anyone can help me out here, pls :(.</p>
  
  <p>I was given an ibm-iaccess64.rpm then converted it to deb using alien. Then installed it: sudo dpkg -i ibm-iaccess64.deb. It was a success.</p>
  
  <p>Then in my /etc/odbcinst.ini I have this config:</p>
  
  <pre><code>[ISERIES]
  Description = iSeries Access ODBC Driver DSN for iSeries
  Driver = iSeries Access ODBC Driver
  System = 192.16.1.1
  UserID = myuserid
  Password = mypassword
  Naming = 0
  DefaultLibraries = QGPL
  Database = MMGSTLIB
  ConnectionType = 0
  CommitMode = 2
  ExtendedDynamic = 0
  DefaultPkgLibrary = QGPL
  DefaultPackage = A/DEFAULT(IBM),2,0,1,0,512
  AllowDataCompression = 1
  LibraryView = 0
  AllowUnsupportedChar = 0
  ForceTranslation = 0
  Trace = 0
  </code></pre>
  
  <p>Then I tried isql -v ISERIES gave me this error:</p>
  
  <blockquote>
    <p>[01000][unixODBC][Driver Manager]Can't open lib
    '/opt/ibm/iSeriesAccess/lib64/libcwbodbc.so' : file not found
    [ISQL]ERROR: Could not SQLConnect</p>
  </blockquote>
  
  <p>I checked the filepath and the libcwbodbc exists >.&lt;...</p>
  
  <p>Hope anyone can help me here :(. Thanks a many</p>