title: how can I leverage native Windows ODBC drivers remotely via fabric?
body: <p>I can connect to a system DSN running <a href="https://bitbucket.org/yekibud/pypyodbc" rel="nofollow">my cygwin compatible fork</a> of <a href="http://code.google.com/p/pypyodbc/" rel="nofollow">pypyodbc</a> locally on Windows 7, but when I try to run the same script via SSH/fabric, I get a permission error:</p>
  
  <pre><code>[192.168.x.x] out:     conn = pyodbc.connect('DSN=xxx;PWD=xxx')
  [192.168.x.x] out:   File "/home/tschmidt/.virtualenvs/dashboard/src/pypyodbc/pypyodbc.py", line 2081, in __init__
  [192.168.x.x] out:     self.connect(connectString, autocommit, ansi, timeout, unicode_results, readonly)
  [192.168.x.x] out:   File "/home/tschmidt/.virtualenvs/dashboard/src/pypyodbc/pypyodbc.py", line 2129, in connect
  [192.168.x.x] out:     validate(ret, SQL_HANDLE_DBC, self.dbc_h)
  [192.168.x.x] out:   File "/home/tschmidt/.virtualenvs/dashboard/src/pypyodbc/pypyodbc.py", line 989, in validate
  [192.168.x.x] out:     ctrl_err(handle_type, handle, ret)
  [192.168.x.x] out:   File "/home/tschmidt/.virtualenvs/dashboard/src/pypyodbc/pypyodbc.py", line 974, in ctrl_err
  [192.168.x.x] out:     raise Error(state,err_text)
  [192.168.x.x] out: pypyodbc.Error: ('HY000', "[HY000] [Microsoft]
      [ODBC Microsoft   Access Driver] The Microsoft Jet database engine cannot 
      open the file '(unknown)'.  It is already opened exclusively by another user, 
      or you need permission to view its data.")
  </code></pre>
  
  <p>Using MDBTools is not an option as I need to make connections to other databases that only have Windows drivers.</p>