title: Installing pyodbc for Python 3.7 on Windows
body: <p>I am a newbie to python and I need to connect to SQL Server.  I run the following command in my DB_Connect.py file.  I run python DB_Connect.py from CMD line and it gives error on <code>import pyodbc</code>.  </p>
  
  <p><a href="https://i.stack.imgur.com/M1Aun.png" rel="noreferrer">Pic of error</a></p>
  
  <p>I then I ran command <code>pip install pyodbc</code> but it give an error saying, "Microsoft Visual C++ 14.0 is required".  I installed "Microsoft Visual C++ 2015 Redistributable" to accommodate this because I would need to get a license for a full version.  My understanding is that this will work.  I still get this error:</p>
  
  <p><a href="https://i.stack.imgur.com/1casP.png" rel="noreferrer">Pic of pip install pyodbc err</a></p>
  
  <p>Do I need to install a full version of Visual C++ or is there a free option?  Why doesnt this CMD work with the Redistributable version?  How do I get past this step?</p>
  
  <p>PC: windows 7 pro - 64
  Python Version: 3.7.0</p>