ODBC permission error when attempting to run pypyodbc.connect under cygwin via fabric

[GoogleCodeExporter]

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/7575b1d44214cf51aa5c24d1bf010b5564fa9
2a4/pypyodbc.py?at=master#cl-456

Please provide any additional information below.

Original issue reported on code.google.com by tschm...@sacfoodcoop.com on 19 Feb 2013 at 5:00

[GoogleCodeExporter]

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

Original comment by tschm...@sacfoodcoop.com on 20 Feb 2013 at 4:01

[GoogleCodeExporter]

Original comment by jiangwen...@gmail.com on 25 Feb 2013 at 2:30

• Added labels: Priority-Low
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Issue 5 has been merged into this issue.

Original comment by jiangwen...@gmail.com on 1 Mar 2013 at 1:36