This was back before the 64 bit ACE drivers were released, and things are better now. There is probably more than there than you would want to read. (If you are interested, I did a few of blog entries "Legacy Connectivity in a 64 bit world" about three or four years ago, covering dbase/foxpro issues, 32/64 bit issues, plus db/2 and other stuff. Getting that going can be a hassle, depending on your infrastructure. First of all, Microsoft Visual FoxPro is a powerful object-oriented environment for database construction and application development. This is usually a problem with delegation and security. You may also find that accessing files on the network is harder than accessing the same file on a local disk. You will want to be sure that the provider representing your drivers (look under the Linked servers folder for the Providers folder) is set to "Allow in process" and. Trying to get it to connect in this environment: Windows 7 Pro - 64bit MS.
There should be plenty of examples of how to create linked servers using ACE drivers (both with TSQL and the SSMS GUI) on the internet. Hi i am trying to connect with visual fox pro driver using. You can just create the linked server and go. With the new drivers, you don't need to create a system DSN like with the old ODBC drivers. The redistributable ACE drivers are available for download on Microsoft's site. The release for Office 2010 that comes in 32 bit and 64 bit versions. They are OLEDB based, but you wouldn't necessarily notice.
These drivers replace the old "JET" drivers and were introduced with Office 2007. On recent versions of SQL Server, 2005+, I've had the best success with the "ACE" drivers. The visual foxpro odbc driver differentiates between database tables and free tables, even when both types of tables are stored in the same directory on your your data source is a directory of free tables, the visual foxpro odbc driver does not catalog or return the names of any tables that are associated with a database. I have had the old ODBC drivers from Microsoft bring down server instances, so i avoid them. The Microsoft Visual FoxPro Driver is available for download at The VFP ODBC Driver can be installed under bit Windows but bit. 64 bit SQL Servers can't use 32 bit ODBC (or OLEDB or anything else) drivers. The first thing to do is to make sure that you are using 32 bit drivers if you have a 32 bit SQL Server and 64 bit drivers if you are using a 64 bit SQL Server.