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
_______________________________________________
Post Messages to: Dabo-dev@mail.leafe.com
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/0C81767F-9375-44E8-95EC-CDF159485D7D@rackspace.com
Author: John Fabiani
Posted: 2012-09-23 12:50:48 Link
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
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/505F4BF8.5070604@jfcomputer.com
Author: John Fabiani
Posted: 2012-09-23 13:02:41 Link
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: Dabo-dev@mail.leafe.com
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/505F4EC1.6060704@jfcomputer.com
Author: John Fabiani
Posted: 2012-09-24 16:40:17 Link
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
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: Dabo-dev@mail.leafe.com
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/5060D341.4030508@jfcomputer.com
Author: John Fabiani
Posted: 2012-09-24 16:41:06 Link
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
>
>
> OK I've got it to open the connect and I can create a connection.
>
>
>
> Any chance you know what command I'm suppose to use to retrieve data
> from a dbf?
>
>
>
> looks like 'select * from tablename' does not work. I can't recall how
> it worked and I do not see anything on the wiki.
>
>
>
>
>
> Johnf
>
>
_______________________________________________
Post Messages to: Dabo-dev@mail.leafe.com
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/5060D372.8090605@jfcomputer.com