Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Foxpro dbf link error

Author  Topic  EddiRae Starting Member 1 Post Posted - 2009-10-27 : 14:24:54 Hello, I have a linked server that is point to the folder where my Foxpro dbf files are located. These are all independent dbf files. There is not a dbc associated with any of them. Here is how I created the linked server: sp_addlinkedserver @server = N'VFP_STS_Data', @srvproduct=N'My Data', @provider=N'VFPOLEDB', @datasrc=N'T:\STS\DATA' Here is the Select query: select * from vfp_sts_data...idfile This is the error that I am getting: Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server Any help would be greatly appreciated. Eddi Rae