Mark,
I had the same thing happen to me. I believe it has to do with how "well" the ODBC driver was written for VFP. I eventually gave up and for small products I use Access. For larger developments, I use SQL Server.