title: How to install pyodbc with Python
body: <p>I'm attempting to create a connection between my Python editor (Eclipse) and SQL server. I thought this would be easy, but has been the complete opposite. I began by attempting to use Pyodbc, but encountered an error saying that module does not exist. I looked into it further, but it seems I may need to install a driver. So, I looked up another method, mysql.connector, but cannot figure out my host name. The below code is what I will be using. If anyone can recommend an easier way, or sees I am doing something wrong, any advice would be appreciated. I'm just trying to connect to sql server, Adventureworks database through Eclipse. </p>
  
  <pre><code>import mysql.connector
  
  cnx = mysql.connector.connect(user= auth_windows,
                            host='unknown',
                            database='AW2014')
  cnx.close()
  </code></pre>