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 HennisHi
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.aspx?scid=kb;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:
> 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
> >
> >|||Hi
Download the the MDAC component checker
http://msdn.microsoft.com/data/mdac/downloads/default.aspx.
You have not said if this is the same database!!!
John
"EvanHennis" wrote:
> 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:
> > 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
> > >
> > >|||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:
> Hi
> Download the the MDAC component checker
> http://msdn.microsoft.com/data/mdac/downloads/default.aspx.
> You have not said if this is the same database!!!
> John
> "EvanHennis" wrote:
> > 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:
> >
> > > 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
> > > >
> > > >|||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 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
>
>|||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|||Hi
I think Cindy has answered this! You can check the file version numbers by
looking at the file properties. If they are different you may have to either
change the way you are doing this or regression test the parts that use the
OLEDB provider.
John
"EvanHennis" wrote:
> 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
>|||I don't know what you mean by saying "Cindy has answered this"? I have
installed the VFP 8 Runtime and it doesn't seem to work. So I don't think it
has anything to do with my install. Is there some place that I can check to
see if I have the VFP OLE DB installed?
--
Evan Hennis
"John Bell" wrote:
> Hi
> I think Cindy has answered this! You can check the file version numbers by
> looking at the file properties. If they are different you may have to either
> change the way you are doing this or regression test the parts that use the
> OLEDB provider.
> John
> "EvanHennis" wrote:
> > 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
> >|||I found the issue. For some reason my installer, which is an ENTIRE different
can of worms, wasn't installing the VFP stuff correctly. I reverted back to
an older version and that fixed my issue. I am still confused that when I
tried to install the run time from a downloaded exe that it didn't work.
Anyway, thanks for all the help.
--
Evan Hennis
"EvanHennis" wrote:
> I don't know what you mean by saying "Cindy has answered this"? I have
> installed the VFP 8 Runtime and it doesn't seem to work. So I don't think it
> has anything to do with my install. Is there some place that I can check to
> see if I have the VFP OLE DB installed?
> --
> Evan Hennis
>
> "John Bell" wrote:
> > Hi
> >
> > I think Cindy has answered this! You can check the file version numbers by
> > looking at the file properties. If they are different you may have to either
> > change the way you are doing this or regression test the parts that use the
> > OLEDB provider.
> >
> > John
> >
> > "EvanHennis" wrote:
> >
> > > 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
> > >|||Hi Evan,
The VFP runtime is different from the OLE DB data provider. The runtime
supports Visual FoxPro applications (EXEs and DLLs), and also access to Fox
data from within those applications. The OLE DB data provider supports
access to Fox data from "outside." I don't know how you installed the
runtime but it doesn't necessarily install the OLE DB data provider, unless
by the "runtime" you mean a full install of the Visual FoxPro IDE, which
will, of course, install 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:BFFC8772-7669-4429-8DA3-892BA5441C02@.microsoft.com...
>I found the issue. For some reason my installer, which is an ENTIRE
>different
> can of worms, wasn't installing the VFP stuff correctly. I reverted back
> to
> an older version and that fixed my issue. I am still confused that when I
> tried to install the run time from a downloaded exe that it didn't work.|||I am not sure why I was worried about the "runtime". It was a long worthless
day so who knows. Any way, the issue was with the VFP OLE DB provider not
getting installed. I redid my installer and it works now.
Thanks,
-- Evan Hennis