MDAC error on VFP linked server -- sql server odbc

Michael
1/28/2005 9:03:32 PM

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!

Cindy Winegarden
1/29/2005 5:06:16 PM

Hi Michael,

Have you tried using the latest Visual FoxPro OLE DB data provider? It's
downloadable from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx and works
with all versions of FoxPro tables.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn.com www.cindywinegarden.com

[quoted text, click to view]

sql server odbc : MDAC error on VFP linked server