title: Pyodbc connecting to Oracle
body: <p>I'm trying to connect to an oracle database with Pyodbc:</p>
  
  <pre><code>pyodbc.connect('{Microsoft ODBC for Oracle};Server=serverxzy.com:1234;Uid=myusername;Pwd=pass123')
  </code></pre>
  
  <p>I get the following error message:</p>
  
  <pre><code>pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
  </code></pre>
  
  <p>Any suggestions how to fix it would be appreciated. I'm specifically interested in getting pyodbc to work and NOT cx_Oracle.</p>