Could not fetch a row from OLE DB provider 'VFPOLEDB'

I keep getting the error "Could not fetch a row from OLE DB provider 'VFPOLEDB' when I do a query on a FoxPro Linked Server through SQL 2000. If the query returns 0 rows I don't get an error I just get the structure of the table. But if the query returns rows I get the error. I can replicate this on a test machine but my development machine works fine.

I have checked the SVRNETCN and the CLICONFG apps in SQL Server and they seem to be set the same on both machines. I am using NamedPipes on the server. I tried starting the DTS and that didn't fix the issue.

Would anyone know what I don't have working correctly?

NOTE: I also posted this in the MSDN Newsgroups

Hi Evan,

First, be sure you have the latest FoxPro and Visual FoxPro OLE DB data provider, downloadable from msnd.microsoft.com/vfoxpro/downloads/updates .

Can you describe your data in more detail? Do you have exactly the same data on the machine that works and the machine that fails? There's a possibility you have some anomaly in the data.

To make sure your linked server is set up correctly, do you have any other data that works on both machines?

What does your query look like? If you select only a few fields, especially character fields since they are the "safest" can you get the expected rows from the bad machine?

|||

Lets leave this answer as me being dumb. My installer isn't working correctly. I wasn't getting some things installed. It is still kind of weird that it would return no rows ok, but once there was data it wouldn't work.