Re: [dabo-dev] Anyone want to test this with VFP?

On 09/23/2012 07:28 AM, Ed Leafe wrote:

> Here's a new pure Python ODBC interface module: http://code.google.com/p/pypyodbc/

> This would be cool if we could use it to talk to VFP, but unfortunately I no longer have VFP available to test with.

> -- Ed Leafe

The doc's suggest that it takes the same parameters (connect string) as

pyodbc.py but I can't seem to get it to work with Fox dbf's. It works

for MS-SQL using the pyodbc connection string. But it seems much slower

than pyodbc (not that pyodbc is fast). The test script seems to imply

it only supports 'Access','Ms-SQL','MySQL' and 'Postgres'. Doc's are

really thin - no 'pypyodbc.__doc__' - I only saw a few test scripts and

a overview.

Below works in pyodbc:

cnxn = pyodbc.connect(DRIVER='{Microsoft FoxPro VFP Driver (*.dbf)}',

SourceType='DBF', SourceDB='c:\amsql\amaddon.dbf')

But the above does not work with pypyodbc.

I could be that the connection string is wrong but with out doc's it's

hard to determine.

I wonder if pypyodbc will be cross platform.

Johnf

_______________________________________________

Post Messages to: Dabo-dev@mail.leafe.com