title: Missing libtdsodbc.so in freetds-dev - MSSQL on Ubuntu
body: <p>I'm trying to get MSSQL working on Ubuntu 12.04 via ODBC, and I've followed these steps to the letter:</p>
  
  <p><a href="http://jamesrossiter.wordpress.com/2011/03/08/connecting-to-microsoft-sql-server-using-odbc-from-ubuntu-server/" rel="noreferrer">http://jamesrossiter.wordpress.com/2011/03/08/connecting-to-microsoft-sql-server-using-odbc-from-ubuntu-server/</a></p>
  
  <p>However, this omits both of these files that are pointed at in odbcinst.ini:</p>
  
  <pre><code>Driver = /usr/lib/odbc/libtdsodbc.so
  Setup = /usr/lib/odbc/libtdsS.so
  </code></pre>
  
  <p>So, I googled a bit and found this:</p>
  
  <p><a href="http://ubuntuforums.org/showthread.php?t=433435&amp;page=2" rel="noreferrer">http://ubuntuforums.org/showthread.php?t=433435&amp;page=2</a></p>
  
  <p>So I followed those instructions and put libtdsodbc.so in /usr/lib/odbc/, but I still get this error:</p>
  
  <pre><code>Can't open lib '/usr/lib/odbc/libtdsodbc.so' : file not found, SQL state 01000 in SQLConnect
  </code></pre>
  
  <p>But...</p>
  
  <pre><code>root@ubuntu:/usr/lib/odbc# ls -la
  total 552
  drwxr-xr-x  2 root root   4096 Aug 19 20:12 .
  drwxr-xr-x 62 root root  12288 Aug 19 19:41 ..
  -rwxrwxr-x  1 root root 270608 Aug 19 20:00 libtdsodbc.so
  </code></pre>
  
  <p>I tried chmod 775 on that file, which explains the permissions. Still no luck.</p>
  
  <p>Any ideas? I'm stumped. Would really love to get this working on my Linux box.</p>
  
  <p>EDIT: I'm using Ubuntu 64-bit. I'm betting this is the problem. Hope that helps...</p>
  
  <p>EDIT2: I tried manually getting the 64-bit package from here:</p>
  
  <p><a href="http://www.ubuntuupdates.org/package/core/precise/main/base/tdsodbc" rel="noreferrer">http://www.ubuntuupdates.org/package/core/precise/main/base/tdsodbc</a></p>
  
  <p>And then I saw there was a file called this:</p>
  
  <pre><code>/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
  </code></pre>
  
  <p>Woo, maybe a 64-bit version, right?</p>
  
  <p>So I pointed odbcinst.ini at it, and it didn't work.</p>