title: unixodbc driver manager cannot open specified library on install
body: <p>I'm using ArchLinux and I am trying to install OpenEdge progress drivers so I can access it via PHP.  I've installed the unixodbc package and the drivers, but when I test the connection via isql or PHP, I get the same error...</p>
  
  <pre><code># isql -3 SUBS2A
  [01000][unixODBC][Driver Manager]Can't open lib '/usr/dlc/odbc/lib/pgoe1023.so' : file not found
  [ISQL]ERROR: Could not SQLConnect
  </code></pre>
  
  <p>The messed up thing is that "/usr/dlc/odbc/lib/pgoe1023.so" presently exists, I even symlinked it from "/usr/dlc".</p>
  
  <p>The following are my .ini files...</p>
  
  <p>odbc.ini</p>
  
  <pre><code>[SUBS2A]
  Description = ODBC Driver for Progress
  Driver = /usr/dlc/odbc/lib/pgoe1023.so
  FileUsage = 1
  </code></pre>
  
  <p>odbcinst.ini (I removed some of the credentials as it is irrelevant)</p>
  
  <pre><code>[ODBC-test]
  Description = SUBS2A
  Driver = SUBS2A
  Server = 192.168.1.2
  Port = 4000
  APILevel=1
  ConnectFunctions=YYN
  CPTimeout=60
  DriverODBCVer=03.60
  FileUsage=0
  SQLLevel=0
  UsageCount=1
  ArraySize=50
  DefaultLongDataBuffLen=2048
  DefaultIsolationLevel= READ COMMITTED
  StaticCursorLongColBuffLen=4096
  </code></pre>
  
  <p><em>EDIT</em> Adding more info...</p>
  
  <p>They appear to both be 32-bit, except I have no idea what I'm doing regarding that.</p>
  
  <pre><code>[root@Crux etc]# file /usr/bin/isql
  /usr/bin/isql: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.27, BuildID[sha1]=0xd1bc16c119                          bb5cad6fea9e2a9abc1d06794a2775, stripped
  [root@Crux etc]# file /usr/dlc/odbc/lib/pgoe1023.so
  /usr/dlc/odbc/lib/pgoe1023.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), dynamically linked, not stripped
  </code></pre>
  
  <p>It does appear that it's missing some dependencies...</p>
  
  <pre><code>[root@Crux lib]# ldd pgoe1023.so
          linux-gate.so.1 =&gt;  (0xb77c2000)
          libpthread.so.0 =&gt; /lib/libpthread.so.0 (0xb7499000)
          librt.so.1 =&gt; /lib/librt.so.1 (0xb7490000)
          libpgicu23.so =&gt; not found
          libdl.so.2 =&gt; /lib/libdl.so.2 (0xb748b000)
          libstdc++-libc6.2-2.so.3 =&gt; not found
          libm.so.6 =&gt; /lib/libm.so.6 (0xb745e000)
          libc.so.6 =&gt; /lib/libc.so.6 (0xb72bc000)
          /lib/ld-linux.so.2 (0xb77c3000)
  </code></pre>
  
  <p><em>UPDATE</em></p>
  
  <p>I copied "libpgicu23.so" to /usr/lib and it solved that problem, but I still need "libstdc++-libc6.2-2.so.3", but when I grabbed one from the internet it said "error while loading shared libraries: /usr/lib/libstdc++-libc6.2-2.so.3: ELF file OS ABI invalid"</p>
  
  <p>I actually even made a symlink from "libstdc++-libc6.2-2.so.3" to "libstdc++.so", but even though it solved the problem via ldd, it caused this error when I queried isql..</p>
  
  <blockquote>
    <p>isql: symbol lookup error: /usr/dlc/odbc/lib/pgoe1023.so: undefined
    symbol: __builtin_vec_new</p>
  </blockquote>
  
  <p>I've never installed odbc on a *nix box, but we did the same thing on a windows box and it worked fine.  Any input appreciated.</p>