> Ken,
> I did download Andy's DataClass together with the article per your suggestions last week. But I could NOT make it work. I even do NOT know how to use ODBC to connect to the demodata shipped with the class. I could get error when testing the class program like:
> [Microsoft][ODBC Visual FoxPro Driver]Field name is a duplicate or invalid.
> [Microsoft][ODBC Driver Manager] ????? SQLSetConnectAttr ????????
> I do not know how to make it work.
> Please help me.
> Regards,
> Nilson

Nilson

Unfortunately Microsoft in their wisdom and urgency to push OLEDB down everyone's gullet, stopped development of the ODBC driver for VFP, I think from version 6 onwards. Therefore you will find that the VFP ODBC driver will not handle some datatypes in 8 & 9 as well as some functions.

You can still download this ODBC Driver by searching for VFP ODBC on this search engine, which does a better job than the site itself :)

http://www.google.com/microsoft.html

After that set up a connection in ODBC (Administration Tools from Control Panel) and you are good to go. The ODBC driver for VFP recognises DBC's and Directories.

However if you choose to use Cursor Adapters then you can use the OLEDB driver to connect to VFP - Search same place as above-this will return Cursors that you can use.