Now, don’t run that reg file as-is because there are some problems with it. This file is located in the C:\Program Files\Microsoft Visual FoxPro 9\Sedna\DDEXProvider\Source\ folder. In the provided source for Sedna’s DDEX Provider there is a file named .reg. Well, the problem is that the Registry still doesn’t have all the information it needs. Then, recompile the RedDDEX (I renamed mine to RegDDEXVS2008.exe) and run itĪs previously stated, after running RegDDEX the DDEX provider still doesn’t show up in the list. Key = My.( “SOFTWARE\Microsoft\VisualStudio\9.0”) Open the MainModule.vb and modify line 44 to read…Ĭonsole.WriteLine( ” Unable to detect Microsoft Visual Studio 2008.”) If you wish to modify the RegDDEX as I did, then go to the source (C:\Program Files\Microsoft Visual FoxPro 9\Sedna\DDEXProvider\Source) and open up the project in Visual Studio. To do the following steps manually, you would copy the to C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE and then add the preceding element to the nfig file. If you are using Visual Studio 2008 then you will need to either do the preceding steps manually or modify the RegDDEX project and recompile it. The element that it adds looks like the following: The RegDDEX.exe simply adds another element to this list. Near the bottom of the nfig file you will find a DbProviderFactories node that has a bunch of elements underneath it.
We have the source code for RegDDEX.exe and a few quick searches on MSDN will provide a wealth of information on how to install a DDEX Provider. Another frustration that many are bound to run into is that the RegDDEX.exe will not even run if you don’t have Visual Studio 2005 installed… I don’t know about you, but I’m using Visual Studio 2008.
In short, the “Microsoft FoxPro Database File (FoxClient)” will not show up in the list when attempting to add a connection from the Server Explorer or when adding a new using the Add New Data Source from the Data menu provided in Visual Studio. Unfortunately, following the outlined steps to the letter will result in very little. If you read the contents of the Readme.txt that comes with Sedna, you would think that the DDEX Provider can be registered for Visual Studio 2005 by simply shelling out to the command prompt and running the included RegDDEX.exe.