Pyodbc installation error on Ubuntu 16.04 with Sql Server installed
<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>