It seems that VFPOLEDB only support queries when it is used via linked server.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dggrfoledbproviderforvisualfoxpro.asp