Hi All.
I'm trying to use Visual Basic and Visual C++ (both 6) with ADO to Query a VFP database, usually this works fine and I'm happy with the results, except when the SQL statement is long (256 characters or over) I recieve the error

[Run-time error '-2147217900 (80040e14)' Command contains unrecognized phrase/keyword]

After speaking to people at DevCon (I can't remember who) I was told that this had been fixed already, but even after updating my OLEDB provider to the one shipped with the VFP 8 beta the error still occurs.

My Connection string is "Provider=vfpoledb.1;Data Source=Path\To\My.DBC", I can post the VB code to repeat my problem if anyone would like me to.

I would be most greatfull if someone could point me in the right direction in fixing this please.

Thanks in Advance.