Malcolm: Great find! I have been looking for this type of information.
Thanks,
Jeff
Jeff Johnson jeff /AT/ san-dc D.O.T com SanDC, Inc. 623-582-0323 Fax 623-869-0675
Malcolm Greene wrote: > Someone recently asked about using SQLite with VFP. > > I've been monitoring the SQLite mail list and stumbled across a post > that referenced the following free ActiveX COM components that provide > an ADO-like interface to SQLite databases. "In theory(tm)" this means > that one could build VFP based SQLite products using these ActiveX > components. Or (in my case) build VFP based utilities to help migrate > VFP/DBF applications to their Python/SQLite equivalents. > > Here's the links: > > dhSQLite > http://www.thecommon.net/2.html > > dhRPCServer (see #5 below!!) > http://www.thecommon.net/8.html > > Some cool features about these free components: > > 1. These are ActiveX components that don't require registry registration > - they can be simply copied and used (great for use on locked down > clients or servers). The technology behind the registration-less use is > described here: http://www.thecommon.net/10.html > > 2. These components have been tested with WINE and not only work, but > perform slightly faster than they do under native Windows. > > 3. These components are compatible with Windows 98SE through Vista. > > 4. Performance claims (vs. Access JET/ADO) are quite impressive. > > 5. The dhRPCServer product provides a multi-user/LAN interface to SQLite > databases that is also XCOPY-deployable!! (I like this approach!!!) > > Malcolm >
©2008 Jeff Johnson |