Coaches use thisall the time to find the strengths and weaknesses of their team. Thus the debugger can show you exactly how the computersees your code.You could think of the debugger as 'instant replay' (or film review) in sports,allowing you to see 'step by step' what happened in a given play. The debugger doesthe same thing. Free computer debugging programs.
Active4 years, 2 months ago
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
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. The Visual FoxPro OLE DB Provider is supported by OLE DB System Components as provided by MDAC 2.6 or later. FoxPro ODBC drivers have been a problems for developers since Vista 64-bit was release. You will have to uninstall the 64-bit version of Office and install the 32-bit version of Office as they both CANNOT be installed on the same system – Ramhound Feb 8 '17 at 17:05 @Ramhound Thanks for your help.
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.
HennoHenno
62255 gold badges1515 silver badges3131 bronze badges
2 Answers
Odbc Visual FoxproHenno
62255 gold badges1515 silver badges3131 bronze badges
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.
Foxpro Oledb Driver
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.)
darin straitdarin strait
Visual Foxpro Ole Db Driverprotected 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? Vfp Ole Db DriverNot the answer you're looking for? Browse other questions tagged sql-serverlinked-servererp or ask your own question.Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |