VFP's ODBC driver understands only DBF/DBC up to version 6. This means: All those new fieldtypes, database events etc from Version 7,8,9 render the MS ODBC driver useless, since he can't open such tables.
VFP7: Database Events VFP8: AutoInc, VFP9: VarChar, VarBinary, Blob The MS OLEDB driver is more modern, and understands all of that stuff. There are also Thirdparty ODBC drivers available, which are fully equipped. The "Advantage Database Server" (now from SAP) has a free ODBC driver. wOOdy -----Ursprüngliche Nachricht----- Von: ProFox <profox-boun...@leafe.com> Im Auftrag von Eric Selje Gesendet: Dienstag, 11. August 2020 03:53 An: ProFox Email List <profox@leafe.com> Betreff: Re: ODBC for VFP Tables You can see my old blog post <https://saltydogllc.com/in-visual-foxpro-using-32-bit-odbc-drivers-on-a-64- bit-machine/> for how to add ODBC drivers, but if you're looking to add ODBC drivers for *VFP* tables, they stopped working after version 7 I believe. Eric _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/039401d66f90$8df11890$a9d349b0$@wondzinski.de ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
