title: how do you connect to oracle using pyodbc
body: <p>I am trying to connect to Oracle db using pyodbc, getting errors. The examples include ms sql server driver:</p>
  
  <p>in my /etc/unixODBC/odbc.ini, I have this entry:</p>
  
  <pre><code>[test_con]
  Driver=Oracle
  Description=data repository db
  Trace=Yes
  ServerName=//db1.example.com:1521/db2_svc1
  
  
  import pyodbc
  cnxn=pyodbc.connect('DSN=test_con, UID=user_id, PWD=passwd123')
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>pyodbc.Error: ('IM012', '[IM012] [unixODBC][Driver Manager]DRIVER keyword syntax error (0) (SQLDriverConnect)')
  </code></pre>