title: connect to Azure SQL database via pyodbc
body: <p>I use pyodbc to connect to my local SQL database which works withoout problems.</p>
  
  <pre><code>SQLSERVERLOCAL='Driver={SQL Server Native Client 11.0};Server=(localdb)\\v11.0;integrated security = true;DATABASE=eodba;'
  cnxn = pyodbc.connect(SQLSERVERLOCAL)   #works
  </code></pre>
  
  <p>I try the connection to the azure sql database with:</p>
  
  <pre><code>SQLSERVERAZURE='Driver={SQL Server Native Client 10.0};Server=tcp:mydatbase.database.windows.net,1433;Database=mydb;Uid=myuser@myerver;Pwd=mypass;Encrypt=yes;Connection Timeout=30;'
  cnxn = pyodbc.connect(SQLSERVERAZURE)   #works not
  </code></pre>
  
  <p>what gives me the error:</p>
  
  <pre><code>[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
  </code></pre>