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

On 09/23/2012 10:50 AM, John Fabiani wrote:

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

>> Here's a new pure Python ODBC interface module:

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

> _______________________________________________

This is also from china - that might account for the lack Doc's

Johnf

_______________________________________________

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