Export to GitHub

pypyodbc - issue #3

does this support foxpro


Posted on Sep 23, 2012 by Massive Bird

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 Camel

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")

Comment #2

Posted on Sep 30, 2012 by Helpful Camel

The 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