Hi, i would appreciate any help with this issue i have come across when trying to access a version 7 dbase from within sql server 2005.

The error message is telling me that "This version of SQL server man studio can only be used toconnect to SQL Server 2000 and SQL servers 2005"

I am new with SQL server so ill explain how imaccessing it. I am connecting a server with sql 2005 on it via net support then through this trying to access another server with v 7 on it.

Thanks for the help in advance.

Is this still an issue?

Thanks!

You can try downloading Visual FoxPro 9.0 provider from the below link http://www.microsoft.com/en-us/download/details.aspx?id=14839

Install it and create a Linked Server in SQL Server using

EXEC sp_addlinkedserver @srvproduct='', @server='DBF', @provider='VFPOLEDB', @datasrc='\\server\DBF_Folder'

where '\\server\DBF_Folder' is the location of the DBF.