title: Run Python script with MSSQL-database connection on Ubuntu Server
body: <p>Im trying to run a script i wrote on a Ubuntu Server.</p>
  
  <p>Im using pypyodbc to connect to a database on a server in the script, and it works great on Windows. </p>
  
  <p>When im trying to run it on my Ubuntu Server i get the following error:</p>
  
  <pre><code>pypyodbc.Error: (u'IM002', u'[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified')
  </code></pre>
  
  <p>This is my connectionstring:</p>
  
  <pre><code>DRIVER = "DRIVER={SQL Server};"
  SERVER = "SERVER=servername;"
  UID = "UID=userid;"
  PWD = "PWD=password;"
  DATABASE = "DATABASE=database_name;"
  
  connection = pypyodbc.connect(DRIVER + SERVER + DATABASE + UID + PWD)
  </code></pre>
  
  <p>What have i done wrong? Any thoughts?</p>
  
  <p>Best Regards.</p>