Could not fetch a row 'VFPOLEDB'

I am running an MSDE of SQL Server 2000 with the latest server pack.
I set up a linked server connecting to a FoxPro database using the vfpoledb
provider.
On my development machine I can get this linked server to work, but on my
test machine, without a full SQL version, I get the error "Could not fetch a
row...". Does anyone have any ideas on how to fix this? I have tried
reinstalling the vfpoledb.exe but that didn't help it.
Evan Hennis
Hi
I am not a VFP expert, but you may want to check that the locations for the
VFP database are correct and that MDAC versions are up-to-date and
consistent, and VFP is patched to the same level.
You may also want to see if your permissions on these machines varies.
If this is working on one machine and not the other implies the mechanism is
correct, although if the data is different it could be a factor.
The are plenty of posts concerning this error and VFP
http://tinyurl.com/94xhx and replies suggest that you check primary keys,
read http://support.microsoft.com/default...b;en-us;207595 ...
John
"EvanHennis" wrote:

> I am running an MSDE of SQL Server 2000 with the latest server pack.
> I set up a linked server connecting to a FoxPro database using the vfpoledb
> provider.
> On my development machine I can get this linked server to work, but on my
> test machine, without a full SQL version, I get the error "Could not fetch a
> row...". Does anyone have any ideas on how to fix this? I have tried
> reinstalling the vfpoledb.exe but that didn't help it.
> --
> Evan Hennis
|||The actual error is:
"Could not fetch a row from OLE DB provider 'VFPOLEDB'
I am trying to connect to a local FoxPro database. Is there some security on
the local computer I need to set?
Evan Hennis
|||Hi
Being able to connecting to the database probably rules out permissions at a
OS level. It is not clear if this is a networked database or separate ones,
if the latter check for differences in the databases. If not it is most
likely environmental e.g. MDAC.
John
"EvanHennis" wrote:

> The actual error is:
> "Could not fetch a row from OLE DB provider 'VFPOLEDB'
> I am trying to connect to a local FoxPro database. Is there some security on
> the local computer I need to set?
> --
> Evan Hennis
>
|||On the test machine I am running Win2000 and I installed the MDAC 2.8. On the
development maching I am in XP Pro. Which I beleive has MDAC 2.8 built in. Is
there a way that I can compare the permissions and such on the MDAC?
Evan Hennis
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Being able to connecting to the database probably rules out permissions at a
> OS level. It is not clear if this is a networked database or separate ones,
> if the latter check for differences in the databases. If not it is most
> likely environmental e.g. MDAC.
> John
>
> "EvanHennis" wrote:
|||Hi
Download the the MDAC component checker
http://msdn.microsoft.com/data/mdac/.../default.aspx.
You have not said if this is the same database!!!
John
"EvanHennis" wrote:
[vbcol=seagreen]
> On the test machine I am running Win2000 and I installed the MDAC 2.8. On the
> development maching I am in XP Pro. Which I beleive has MDAC 2.8 built in. Is
> there a way that I can compare the permissions and such on the MDAC?
> --
> Evan Hennis
>
> "John Bell" wrote:
|||Same Database? Well, each computer has its own MSDE instance on it. They are
both connecting to a FoxPro database on the development machine. BUT, I have
tried connecting to a local FoxPro database on the test machine and it
doesn't work. But if I try to connect to a local database on the development
machine it works fine.
Evan Hennis
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Download the the MDAC component checker
> http://msdn.microsoft.com/data/mdac/.../default.aspx.
> You have not said if this is the same database!!!
> John
> "EvanHennis" wrote:
|||Hi Evan,
It may not solve your problem, but be sure you've got the latest VFP OLE DB
provider (VFP9), downloadable from
http://msdn.microsoft.com/vfoxpro/downloads/updates . It is not included
with an MDAC installation.
Are you trying to read data or update data? Updating VFP data via a linked
server was not supported in earlier versions of the OLE DB data provider.
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"EvanHennis" <EvanHennis@.discussions.microsoft.com> wrote in message
news:1628DF07-BF7C-4265-8B19-00733D8CA75F@.microsoft.com...
>I am running an MSDE of SQL Server 2000 with the latest server pack.
> I set up a linked server connecting to a FoxPro database using the
> vfpoledb
> provider.
> On my development machine I can get this linked server to work, but on my
> test machine, without a full SQL version, I get the error "Could not fetch
> a
> row...". Does anyone have any ideas on how to fix this? I have tried
> reinstalling the vfpoledb.exe but that didn't help it.
> --
> Evan Hennis
|||Thanks for responding but I can't use the latest VFP OLE DB because we have a
pretty large application and I can't make a change like that. I am trying to
do a normal read, Updates are not supported.
I had this working at one point so I am stumped.
Evan Hennis
"Cindy Winegarden" wrote:

> Hi Evan,
> It may not solve your problem, but be sure you've got the latest VFP OLE DB
> provider (VFP9), downloadable from
> http://msdn.microsoft.com/vfoxpro/downloads/updates . It is not included
> with an MDAC installation.
> Are you trying to read data or update data? Updating VFP data via a linked
> server was not supported in earlier versions of the OLE DB data provider.
> --
> Cindy Winegarden MCSD, Microsoft Most Valuable Professional
> cindy_winegarden@.msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
> "EvanHennis" <EvanHennis@.discussions.microsoft.com> wrote in message
> news:1628DF07-BF7C-4265-8B19-00733D8CA75F@.microsoft.com...
>
>
|||I downloaded the Component Checker and I don't see the VFPOLEDB.dll in the
list of files. Could this be the issue?
Evan Hennis