MDAC error on VFP linked server

I have a linked server pointing to a folder where foxpro tables exist.
The tables are listed when I click on the linked server/tables.
However I get this error when in query analyer I say: select * from
vfplinked...clients
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'.
OLE DB error trace [Non-interface error: Invalid schema or catalog
specified for the provider.].
Any help? What am I missing? I got this working before.
This is on SQLServer 2000
Thanks everyone!Hi Michael,
Have you tried using the latest Visual FoxPro OLE DB data provider? It's
downloadable from
http://msdn.microsoft.com/vfoxpro/d...es/default.aspx and works
with all versions of FoxPro tables.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"Michael" <Michael.Rodriguez@.nospam> wrote in message
news:etkRi$bBFHA.2180@.TK2MSFTNGP10.phx.gbl...
> I have a linked server pointing to a folder where foxpro tables exist.
> The tables are listed when I click on the linked server/tables.
> However I get this error when in query analyer I say: select * from
> vfplinked...clients
> Server: Msg 7313, Level 16, State 1, Line 1
> Invalid schema or catalog specified for provider 'MSDASQL'.
> OLE DB error trace [Non-interface error: Invalid schema or catalog
> specified for the provider.].
>
> Any help? What am I missing? I got this working before.
> This is on SQLServer 2000
> Thanks everyone!
>