Thursday, June 23, 2011

OLE DB provider "VFPOledb.1" has not been registered

I was trying to create a Linked Server on SQL SERVER 2008 R2 Server to connect to Foxpro database on a Windows 7 PC. I installed the Visual FoxPro 9.0 OLE DB provider and when I accessed the linked server, I got the above error.

Solution

Un-install the Visual FoxPro 9.0 OLE DB provider
Install the Provider for all users instead of current user and it will fix the problem.