title: Pyodbc installation error on Ubuntu 16.04 with Sql Server installed
body: <p>I am trying to test my scripts for data migration from <code>mssql-server</code> to <code>oracle server</code>. For this, I have to install <code>pyodbc</code> <code>python</code> package for <strong>Ubuntu</strong>, it has the dependency of <code>unixodbc</code>. When I try to install <code>unixodbc-dev</code> using:</p>
  
  <pre><code>sudo apt-get install unixodbc-dev
  </code></pre>
  
  <p>It gives <strong>broken packages error</strong>:</p>
  
  <pre><code>The following packages have unmet dependencies:
   unixodbc-dev : Depends: unixodbc (= 2.3.1-4.1)
                  Depends: odbcinst1debian2 (= 2.3.1-4.1) but it is not going to be installed
  E: Unable to correct problems, you have held broken packages.
  </code></pre>
  
  <p>But with <em>aptitude</em> (<code>sudo aptitude install unixodbc-dev</code>) it is <strong>installing</strong> and <strong>also removing some SQL server files</strong> due to which my <code>SQL-server</code> goes down. </p>
  
  <p>Again on installing <code>SQL server</code> with this command:</p>
  
  <pre><code>sudo apt-get install mssql-server mssql-tools -y
  </code></pre>
  
  <p>it removes <code>unixodbc</code>:</p>
  
  <pre><code>Removing unixodbc-dev (2.3.1-4.1) ...
  Removing unixodbc (2.3.1-4.1) ...
  Removing libodbc1:amd64 (2.3.1-4.1) ...
  Removing odbcinst (2.3.1-4.1) ...
  Removing odbcinst1debian2:amd64 (2.3.1-4.1) ...
  </code></pre>
  
  <p>Hence again, I am left only with <code>SQL-server</code> and <strong>no</strong> <code>unixodbc</code>(<em>pyodbc doesn't works</em>). I understand that there is some dependency issue between both of the packages.</p>
  
  <p>Is there is a way to Install both on the same machine or do I have to use 2 machines here?</p>