What steps will reproduce the problem? 1.Execute pypyodbc.connect on remote host under Cygwin/Cygwin Python2.7.3 via fabric.

What is the expected output? What do you see instead? The same script makes the connection as expected when run from the same machine as the ODBC DSN, but when ran remotely via fabric, I get the following error:

[192.168.1.30] out: conn = pyodbc.connect('DSN=xxx;PWD=xxx') [192.168.1.30] out: File "/home/tschmidt/.virtualenvs/dashboard/src/pypyodbc/pypyodbc.py", line 2081, in init [192.168.1.30] out: self.connect(connectString, autocommit, ansi, timeout, unicode_results, readonly) [192.168.1.30] out: File "/home/tschmidt/.virtualenvs/dashboard/src/pypyodbc/pypyodbc.py", line 2129, in connect [192.168.1.30] out: validate(ret, SQL_HANDLE_DBC, self.dbc_h) [192.168.1.30] out: File "/home/tschmidt/.virtualenvs/dashboard/src/pypyodbc/pypyodbc.py", line 989, in validate [192.168.1.30] out: ctrl_err(handle_type, handle, ret) [192.168.1.30] out: File "/home/tschmidt/.virtualenvs/dashboard/src/pypyodbc/pypyodbc.py", line 974, in ctrl_err [192.168.1.30] out: raise Error(state,err_text) [192.168.1.30] 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.")

What version of the product are you using? On what operating system?

Running from the my pypyodbc fork with the latest changes merged from rev e657d5acbc5f on the bitbucket repo plus my Cygwin compatibility modifications: https://bitbucket.org/yekibud/pypyodbc/src/7575b1d44214cf51aa5c24d1bf010b5564fa92a4/pypyodbc.py?at=master#cl-456

Please provide any additional information below.

I was able to work around this by switching to Windows XP.

Issue 5 has been merged into this issue.