title: pypyodbc connection to sql server
body: <p>Trying to connect to sql server with pypyodbc, but I keep getting the "data source name not found and no default driver specified" error. See below attempt. I'm fairly new to all this, but still thought at least testing a connection would be easier. </p>
  
  <pre><code>import pypyodbc
  
  connection = pypyodbc.connect("DRIVER = {SQL Server}; Server = servername;Trusted_Connection = Yes")
  connection.close()
  </code></pre>