does this support foxpro

[GoogleCodeExporter]

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?
a connection

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


Please provide any additional information below.
cnxn = pypyodbc.connect(DRIVER='{Microsoft FoxPro VFP Driver (*.dbf)}',  
SourceType='DBF',  SourceDB='c:\amsql\amaddon.dbf')
does not work
TypeError: connect() got an unexpected keyword argument 'DRIVER'
but works with pyodbc.  Maybe you can suggest a different connect string?

Original issue reported on code.google.com by fabiani....@gmail.com on 23 Sep 2012 at 5:59

[GoogleCodeExporter]

Hi, it should support FoxPro.

The problem you meet here, is the method in pypyodbc currently only support a 
connection string as the input, while pyodbc provide you another way to specify 
the connection via a set of parameters (Driver/SourceType/SourceDB, etc)

You can try this as a workaround:

pypyodbc.connect("DRIVER={Microsoft Visual FoxPro 
Driver};SourceType=DBF;SourceDB=c:\amsql\amaddon.dbf")

Original comment by jiangwen...@gmail.com on 24 Sep 2012 at 1:22

• Changed state: Accepted

[GoogleCodeExporter]

The new pypyodbc.py in the Trunk should have fixed this issue.

Original comment by jiangwen...@gmail.com on 30 Sep 2012 at 1:22

• Changed state: Started

[GoogleCodeExporter]

Original comment by jiangwen...@gmail.com on 9 Oct 2012 at 5:14

• Changed state: Fixed