title: "[unixODBC][Driver Manager]Can't open lib '/usr/lib/x86_84-linux-gnu/odbc/libmyodbc8w.so' : file not found"
body: <p>Not used to linux at all so forgive me. It seems as though I have been through every post online for this issue and I've finally come to post my own.</p>
  <p>I need to connect to a MySQL Database via an ODBC connector. I know javascript so I am using <a href="https://github.com/markdirish/node-odbc/" rel="nofollow noreferrer">nodes odbc module</a>. I have successfully built unixodbc and all of that.</p>
  <p>My odbc.ini is located in /etc/ and looks like this (I've obfuscated some parts):</p>
  <pre><code>[eFaradayDSN]
  Description = ****
  Driver = MySQL ODBC 8.0 Unicode Driver
  Server = **.**.*.45
  User = ***
  Password = *****
  Port = 3306
  Database = ****
  </code></pre>
  <p>My odbcinst.ini is location in /etc/ also and looks like:</p>
  <pre><code>[MySQL ODBC 8.0 Unicode Driver]
  Driver=/usr/lib/x86_84-linux-gnu/odbc/libmyodbc8w.so
  UsageCount=1
  
  [MySQL ODBC 8.0 ANSI Driver]
  Driver=/usr/lib/x86_84-linux-gnu/odbc/libmyodbc8a.so
  UsageCount=1
  
  [eFaradayDSN]
  Description = ***
  Driver = MySQL ODBC 8.0 Unicode Driver
  Server = **.**.*.45
  User = ****
  Password = *****
  Port = 3306
  Database = *****
  </code></pre>
  <p>Doing an odbcinst -j returns:</p>
  <pre><code>odbcinst -j
  unixODBC 2.3.6
  DRIVERS............: /etc/odbcinst.ini
  SYSTEM DATA SOURCES: /etc/odbc.ini
  FILE DATA SOURCES..: /etc/ODBCDataSources
  USER DATA SOURCES..: /root/.odbc.ini
  SQLULEN Size.......: 8
  SQLLEN Size........: 8
  SQLSETPOSIROW Size.: 8
  </code></pre>
  <p>There are no missing dependencies showing via ldd:</p>
  <pre><code>ldd -v /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
  </code></pre>
  <p>I have updated the LD_LIBRARY_PATH, PATH and ODBCINI env variables:</p>
  <pre><code>SHELL=/bin/bash
  PWD=/root
  LOGNAME=root
  XDG_SESSION_TYPE=tty
  MOTD_SHOWN=pam
  HOME=/root
  LANG=en_US.UTF-8
  ODBCINI=/etc/odbc.ini
  LESSCLOSE=/usr/bin/lesspipe %s %s
  XDG_SESSION_CLASS=user
  TERM=xterm-256color
  LESSOPEN=| /usr/bin/lesspipe %s
  USER=root
  SHLVL=1
  XDG_SESSION_ID=454
  LD_LIBRARY_PATH=/usr/lib/x86_64-linux-gnu/odbc/
  XDG_RUNTIME_DIR=/run/user/0
  SSH_CLIENT=86.206.239.102 51232 22
  PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin:/usr/lib/x886+64-linux-gnu/odbc
  DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/0/bus
  SSH_TTY=/dev/pts/3
  OLDPWD=/etc/ODBCDataSources
  </code></pre>
  <p>What am I doing wrong? Thanks</p>
  <p><strong>UPDATE</strong></p>
  <p>I reinstalled the .deb odbc connector driver (I think that is what is is) and now when running my node program I have a new error:</p>
  <pre><code>[Error: [odbc] Error connecting to the database] {
  
  
  odbcErrors: [
      {
        state: 'HY000',
        code: 1045,
        message: &quot;[MySQL][ODBC 8.0(a) Driver]Access denied for user '&lt;the username in my DSN&gt;'@'127.0.0.1 &lt;I have also tried the actual ip here&gt;' (using password: YES)&quot;
      }
    ]
  }
  </code></pre>
  <p>So the message source has changed from unixODBC to MySQL - I assume that means I am reaching the database server ok now...?</p>