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:
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
_______________________________________________
This is also from china - that might account for the lack Doc's
Johnf
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/[email protected]