Cannot create an instance of OLE DB provider “VFPOLEDB” for linked server “Opera”.
28-Aug-0909 Leave a comment
Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider “VFPOLEDB” for linked server “”.
Click here for one part of solution Social.msdn
in Server Objects > Linked Servers > Providers > VFPOLEDB > General tab > Provider options > Allow inprocess. Also, you can
change the InProcess setting with the following code:
USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N’VFPOLEDB’, N’AllowInProcess’, 1
GO
Then get a new message
OLE DB provider “VFPOLEDB” for linked server “Opera” returned message “Invalid path or file name.”.
Cannot initialize the data source object of OLE DB provider “VFPOLEDB” for linked server