Carl Karsten wrote: >>> 5. Has anyone successfully managed to access VFP data (read and write) using >>> anything other than the PHP ADODB software >>> >>> http://phplens.com/lens/adodb/adodb-py-docs.htm >>> >>> in addition to the mxODBC software >>> >>> http://www.egenix.com/products/python/mxODBC/ >>> >> >> if you need odbc support I would also try ceODBC package. > > I agree. I am using http://ceodbc.sourceforge.net with c-tree odbc drivers. > the > c-tree driver has a bug, and the ceodbc author (Anthony Tuininga) built in a > work around in under a day. He also gave me some tips to make my code better. > Did you know you could do: > > connection = connect... > srcCur = connection.cursor() > srcCur.execute('bla bla bla') > > for row in srcCur: > rowNo = srcCur.rowcount > > I was doing: for rowNo, row in enumerate(srcCur.fetchall()) > > He is also the author of the Oracle db module. guessing that counts for > something. > > However, I would put dbf access aside and look at changing the VFP app from > dbf > to postgresql or mysql. Although a dabo odbc module would more productive > for > the rest of the world. tough call.
I think where you want to use DBF, you should use sqlite, especially if it is single-user. For everything else, you should use PostgreSQL, MySQL, or Firebird. You can use Oracle or MS-SQL if you have to, or for some reason if you really want to, but why bother? Paul -- http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
