> You don't have to. Everything is in readme. It's just matter of > reading it. Seriously.
Well for an average person like me it took me awhile to 'find' where everything was... actually it was seriously more than a couple of hours. The readme was virtually non-descript. >> Microsoft Visual Studio Error "Unable to load DLL 'fbembed': The >> specified >> module could not be found (Exception from HRESULT: 0x8007007E) > > You're missing some file fbembed depends on. OK... I found out how to fix this. I'll include the fix below with an amended version of the installation facts of which I have found. To answer how to generate an EDMX file you can go through the steps below (***I wish these steps were embedded in the DDEX readme file - it would have been a lot easier and faster to get things running***) you can download the DDEX provider here: (http://www.firebirdsql.org/index.php?op=files&id=netprovider) and save it to a specified folder. Create a connection string in your app.config file by going through the VS GUI prompts for a new datasource. Then go through the options/steps of 'Add New Item', 'ADO.NET Entity Data Model' and follow the prompts. I could have just created a connection string programmatically (which I had no problem of doing and getting it to work - I just couldn't get the VS GUI to work - which is why I did it this way) or creating a connection going through the projects settings and using that connection to generate the EDMX file. To install the DDEX provider: --------------------------------------------------------------------------------------------------------------- Firebird Data Access Designer DDEX installation Prerequisites 1. Make sure that you have Visual Studio .NET 2005 Standard or higher edition. 2. Express editions are not supported. Install the Firebird Client to the GAC 1. Install the FirebirdSql.Data.FirebirdClient.dll into the GAC (although - I have successfully ran with it outside of the GAC by referencing it inside of my project and including it locally - for general purposes - I would install it to the GAC). Registry update 1. Install the .reg file into the registry for your system. 2. Open Regedit or another registry tool and update the path in FirebirdDDEXProviderPackageLess32.reg or FirebirdDDEXProviderPackageLess64.reg registry entry. 3. The Win7 64bit registry file should be in: HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\VisualStudio\9.0\DataProviders 4. You can do a search for "FirebirdSql.VisualStudio.DataTools" in HKEY_LOCAL_MACHINE\Software\ to speed up the process. 5. The places where to update it is marked %Path%. This should be in "CodeBase". 6. Put in the full path to the FirebirdSql.VisualStudio.DataTools.dll that you have saved to a folder for this purpose. Machine.config update Add the following two sections to machine.config (located usually at C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config and C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\CONFIG\machine.config on 64-bit system). To do this you have to run the editing application (whether it is notepad or Visual Studio) as an administrator (Properties on the short cut for the application - advanced tab - enable the option to 'run as administrator') <configuration> ... <configSections> ... <section name="firebirdsql.data.firebirdclient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> ... </configSections> ... <system.data> <DbProviderFactories> ... <add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=%Version%, Culture=%Culture%, PublicKeyToken=%PublicKeyToken%" /> ... </DbProviderFactories> </system.data> ... </configuration> And substitute: %Version% With the version of the provider assembly that you have in the GAC. %Culture% With the culture of the provider assembly that you have in the GAC. %PublicKeyToken% With the PublicKeyToken of the provider assembly that you have in the GAC. VS2008 - needed support files to be added - Embedded version Add the following files to the Program Files Folder for VS2008 which is located at: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7 for 64bit systems. fbembed.dll, ib_util.dll, icudt30.dll, icuin30.dll, icuuc30.dll, msvcp80.dll, msvcr80.dll -------------------------------------------------------------------------------------------------------- I haven't explored -exactly- what was needed, I just included all of the above in that folder (Program Files Folder for VS2008) and the VS GUI worked as expected. It may be possible to eliminate some of those with further testing. Also I changed the first mod in the Machine.config to match the second modification even thought it didn't call for it. I don't know what difference that would/will make. Hope this helps someone else who is trying to install the DDEX provider... ------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
