1. Visual Foxpro Odbc Driver Windows Server 2008 R2d2
2. Visual Foxpro Odbc Driver Windows Server 2008 R2 64 Bit

Apr 07, 2010  Hi, I assume you are running a Windows Server 2008 64 BIT OS. Currently MS do not provide a 64-bit version of ODBC drivers for VisualFox Pro and Access. Currently MS do not provide a 64-bit version of ODBC drivers for VisualFox Pro and Access. I work with sql server 2008 and windows server 2008.I configure target in odbc properties to%SystemRoot% SysWOW64 odbcad32.exe and add microsoft visual. Jun 15, 2011 How do I install ODBC driver on Windows Server 2008 R2 to. FoxPro; Windows Server 2008; 4. I tried installing the VFP ODBC driver. The ODBC Driver for SQL Server compatibility page. SQL Server 2008 R2 (including Express edition). SQL Server 2008 (including. Microsoft SQL Server Data Tools, Yes. Microsoft Visual FoxPro, Yes. Download Visual Foxpro Odbc Driver Windows Server 2008 R2. Now, I finally get to find out if we can run the fully patched Microsoft Visual FoxPro 9.0 SP2 Version.7423 on Windows 10. So, I launch it from the. Microsoft Data Access Components (MDAC; also known as Windows DAC) is a framework of interrelated Microsoft technologies that allows. Visual FoxPro cannot use 64-bit ODBC drivers however. You can use 32-bit ODBC drivers on 64-bit Windows, but you must set them up in the 32-bit ODBC Administrator. This is not the one that’s going to come up if you go through Control Panel. To invoke it, run C: Windows SysWow64 odbcad32.exe and add your DSNs there.

May 16, 2008  Date Published: 5/16/2008. File Size: 1.2 MB. The Visual FoxPro OLE DB Provider (VfpOleDB.dll) exposes OLE DB interfaces that you can use to access Visual FoxPro databases and tables from other programming languages and applications.

We're trying to access Foxpro file-based database files via MSSQL Server's linked server feature, using Foxpro ODBC driver.

For this, we've

• installed the latest Foxpro ODBC Driver from Microsoft,
• made a System DSN which is using this driver
• chose the 'Visual FoxPro database (.DBC)' option under Database type, instead of 'Free table directory'
• specified the path to our dbc file (on local machine)
• installed MSSQL Server 2008 R2 Express
• installed MSSQL Server Management Studio 2008
• tried to create a new linked server by using a GUI wizard like this:

But the last step never completes (Executing is displayed forever).When Management Studio is forcibly closed and restarted the new linked server is there but only contains Catalogues subitem. If we try to expand it, Management Studio goes into loop yet again.

2 Answers

• Download and install Microsoft OLE DB Provider for Visual FoxPro
• Make sure it appears in MSSQL Management Studio, under System Objects > Linked Servers > Providers, as 'VFPOLEDB'. I had to install it, uninstall it and re-install it until I got it there (and no, restarting Windows did not work).
• Open System Objects, right click Linked Servers and choose to add a new linked server.
• Fill the form as like this:
  • No need to add any DSNs in ODBC applet
  • Click OK and see if you can now drill down the new linked server until you see the tables.
  • Right click on some table and script a SELECT query to new query window. This gives you an example how to query this new linked server:
    SELECT * FROM [myLinkedServer]...[myTable]

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. 64 bit SQL Servers can't use 32 bit ODBC (or OLEDB or anything else) drivers.

I have had the old ODBC drivers from Microsoft bring down server instances, so i avoid them.

On recent versions of SQL Server, 2005+, I've had the best success with the 'ACE' drivers. These drivers replace the old 'JET' drivers and were introduced with Office 2007. They are OLEDB based, but you wouldn't necessarily notice. The release for Office 2010 that comes in 32 bit and 64 bit versions. The redistributable ACE drivers are available for download on Microsoft's site.

With the new drivers, you don't need to create a system DSN like with the old ODBC drivers. You can just create the linked server and go. 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.

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 .

You may also find that accessing files on the network is harder than accessing the same file on a local disk. This is usually a problem with delegation and security. Getting that going can be a hassle, depending on your infrastructure.

(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. There is probably more than there than you would want to read. This was back before the 64 bit ACE drivers were released, and things are better now.)

protected by Michael Hampton♦Aug 11 '15 at 16:53

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged sql-serverlinked-servererp or ask your own question.

Cannot Connect to SQL Server 2008 Express FromVFP 9 Program (exe)

Visual Foxpro Odbc Driver Windows Server 2008 R2d2

Cannot Connect to SQL Server 2008 Express FromVFP 9 Program (exe)

Visual Foxpro Odbc Driver Windows Server 2008 R2 64 Bit