I am trying to link FoxPro files in MS SQL Server 2008 via Linked Server. However, while doing so, Im getting the following error:
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" has not been registered.
I have also installed Microsoft Visual FoxPro OLE DB. I thought by installing it, it will register it but it did not.
exec sp_addlinkedserver @server = 'temp',
@srvproduct = 'VFP',
@provider = 'VFPOLEDB',
SELECT * FROM temp...sys1map
sp_dropserver @server = 'temp'