On Wednesday 07 June 2006 10:18, Paul McNett wrote: > At the very least, we should get the pyodbc stuff working, and then > provide a vfp abstraction layer that uses odbc. This would allow a > Windows-based dabo application to talk to VFP data. I believe it would > also mean we could connect via Linux and Mac using Samba mounts as well. > I'll enter this as a tracker issue and assign it to me. I'm pretty sure > I had POC code that did just this, years ago.
I too used somesort of ???.py that allowed me to transfer data from DBF into Postgres. But all I did was extract data. There is a simple routine at ASPN. But it would require lots of added code to make it work with dabo. Also it does not appear to work with VFP 9 tables. But it could be a starting point. I believe the xBase people have a c++ interface that could be use for the start of an ODBC driver for unixODBC. There is also mxODBC and I think that's GPL (not sure). With pyodbc you still need to create some way to access the M$ FoxPro ODBC driver. I doubt writting a VFP abstraction layer would be easy. BTW what are you thinking would work? It might be easier to setup access to MsSQL for the demo (assuming that the VFP group need to see something they would normally do). There is a free driver for Linux - freetds.org. John _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
