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?
Comment #1
Posted on Sep 24, 2012 by Helpful CamelHi, 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")
Comment #2
Posted on Sep 30, 2012 by Helpful CamelThe new pypyodbc.py in the Trunk should have fixed this issue.
Comment #3
Posted on Oct 9, 2012 by Helpful Camel(No comment was entered for this change.)
Status: Fixed
Labels:
Type-Defect
Priority-Medium