Menu
▾
▴
Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests
|
From: Bradburn, G. (LNG-RDU) <gre...@le...> - 2013-08-02 21:00:40
|
Same error. What does your Reference include statement look like? Also, what is in your machine.config file? -----Original Message----- From: Hernan Martinez [mailto:her...@ob...] Sent: Friday, August 02, 2013 4:50 PM To: For users and developers of the Firebird .NET providers Cc: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests Humm. I bet the error is because of the version mismatch. You can try deleting the reference and adding it again. Hernán MF El 02/08/2013, a las 22:44, "Bradburn, Greg (LNG-RDU)" <gre...@le...> escribió: > Yes sir: > <Reference Include="FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL"> > <SpecificVersion>False</SpecificVersion> > <Private>True</Private> > </Reference> > > I am curious why it says version 2.0.0.0 in the Reference Include statement but when I look at the Reference properties in Solution Explorer it says: > Version 3.0.2.0 > Runtime Version: 4.0.30319 > > I noticed Copy Local was false. I changed it to true but still get the error. > > -----Original Message----- > From: Hernán Martínez [mailto:her...@ob...] > Sent: Friday, August 02, 2013 4:27 PM > To: For users and developers of the Firebird .NET providers > Subject: Re: [Firebird-net-provider] Error finding .Net provider but > only in unit tests > > Did you add the reference to the firebirdclient dll in the test project? > > Hernán MF S > > El 02/08/2013, a las 22:18, "Bradburn, Greg (LNG-RDU)" <gre...@le...> escribió: > >> Thanks again for the reply, >> >> My LocalTestRun.testrunconfig has the following deployment items: >> <Deployment> >> <DeploymentItem filename="Core\Core Unit Tests\FirebirdEmbedded\" /> >> <DeploymentItem >> filename="Core\Juris.DataAccessLayer.CacheManagement\InitialCache.fdb. >> zip" /> </Deployment> >> >> The FirebirdEmbedded folder contains: >> aliases.conf >> doc <dir> >> fbembed.dll >> firebird.conf >> firebird.msg >> ib_util.dll >> icudt30.dll >> icuin30.dll >> icuuc30.dll >> IDPLicense.txt >> Intl <dir> >> IPLicense.txt >> Microsoft.VC80.CRT.manifest >> msvcp80.dll >> msvcr80.dll >> Readme.txt >> Udf <dir> >> >> My test class has the following attributes decorating it: >> [TestClass] >> [DeploymentItem(@"InitialCache.fdb.zip")] >> [DeploymentItem(@"FirebirdEmbedded\aliases.conf")] >> [DeploymentItem(@"FirebirdEmbedded\fbembed.dll")] >> [DeploymentItem(@"FirebirdEmbedded\firebird.conf")] >> [DeploymentItem(@"FirebirdEmbedded\firebird.msg")] >> [DeploymentItem(@"FirebirdEmbedded\ib_util.dll")] >> [DeploymentItem(@"FirebirdEmbedded\icudt30.dll")] >> [DeploymentItem(@"FirebirdEmbedded\icuin30.dll")] >> [DeploymentItem(@"FirebirdEmbedded\icuuc30.dll")] >> [DeploymentItem(@"FirebirdEmbedded\IDPLicense.txt")] >> [DeploymentItem(@"FirebirdEmbedded\IPLicense.txt")] >> [DeploymentItem(@"FirebirdEmbedded\Microsoft.VC80.CRT.manifest")] >> [DeploymentItem(@"FirebirdEmbedded\msvcp80.dll")] >> [DeploymentItem(@"FirebirdEmbedded\msvcr80.dll")] >> [DeploymentItem(@"FirebirdEmbedded\intl")] >> [DeploymentItem(@"FirebirdEmbedded\udf")] >> >> My unit test Setup method also has code to manually copy the firebird files to the executing folder (this is ancient code that I inherited). >> >> I have verified that the C:\Users\Bradbuga\AppData\Local\Temp\TestResults\bradbuga_LNGRDUB-4157824 2013-07-31 15_41_36\Out folder contains all of those files, including the intl and Udf folders with all their contents, along with all the assemblies needed to run the tests. >> >> There is also a couple of "Deploy" folders under TestResults but nothing is in them. >> >> Thanks in advance for anything else you can think of. Since, I take it, your unit tests run fine, and that I must be doing something wrong. >> >> Regards, >> >> Greg. >> -----Original Message----- >> From: Hernan Martinez [mailto:her...@ob...] >> Sent: Friday, August 02, 2013 3:35 PM >> To: For users and developers of the Firebird .NET providers >> Subject: Re: [Firebird-net-provider] Error finding .Net provider but >> only in unit tests >> >> Well, yours seems fine besides the DLL full name. >> My Test.config is as follows (the rest is just a couple of appSettings keys) : >> >> <system.data> >> <DbProviderFactories> >> <remove invariant="FirebirdSql.Data.FirebirdClient"/> >> <add name="FirebirdSql Data Provider" >> invariant="FirebirdSql.Data.FirebirdClient" >> description=".Net Framework Data Provider for FirebirdSql" >> type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, >> Version=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" >> /> >> </DbProviderFactories> >> </system.data> >> >> >> I have also in my LocalTestRun.testrunconfig the following section to make sure all the DLLs are in the test execution directory: >> >> <Deployment> >> <DeploymentItem filename="Externals\icuin30.dll" /> >> <DeploymentItem filename="Externals\icudt30.dll" /> >> <DeploymentItem filename="Externals\fbembed.dll" /> >> <DeploymentItem filename="Externals\icuuc30.dll" /> </Deployment> >> >> >> El 02/08/2013, a las 16:00, "Bradburn, Greg (LNG-RDU)" <gre...@le...> escribió: >> >>> Hernán, >>> >>> Can you elaborate on what you mean by "Firebird's entry"? >>> >>> The app.config for the application, where Firebird works, has the following relevant entries: >>> <configuration> >>> <configSections> >>> <section name="cachingConfiguration"type="Microsoft.Practices.EnterpriseLibrary.Caching.Configuration.CacheManagerSettings, Microsoft.Practices.EnterpriseLibrary.Caching, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/> >>> <section name="dataProviderFactory"type="Juris.DataAccessLayer.Factory.DataProviderFactoryConfiguration, Juris.DataAccessLayer.Factory" allowLocation="true" allowDefinition="Everywhere"restartOnExternalChanges="true"/> >>> <section >>> name="netTiersService"type="Juris.DataAccessLayer.Bases.NetTiersServ >>> i >>> c eSection, >>> Juris.DataAccessLayer"allowDefinition="MachineToApplication" >>> restartOnExternalChanges="true"/> </configSections> >>> >>> <system.data> >>> <DbProviderFactories> >>> <add name="Firebird Data Provider"invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient"/> >>> </DbProviderFactories> >>> </system.data> >>> >>> <netTiersService> >>> <providers> >>> <add name="FirebirdNetTiersProvider"type="Juris.DataAccessLayer.FirebirdClient.FirebirdNetTiersProvider, Juris.DataAccessLayer.FirebirdClient" useStoredProcedure="true"providerInvariantName="FirebirdSql.Data.FirebirdClient"providerName="FirebirdSql.Data.FirebirdClient"entityFactoryType="Juris.Entities.EntityFactory" enableEntityTracking="true"enableMethodAuthorization="false" useEntityFactory="true" commandTimeout="30"/> >>> <add name="SqlNetTiersProvider" useStoredProcedure="true"enableEntityTracking="true" type="Juris.DataAccessLayer.SqlClient.SqlNetTiersProvider, Juris.DataAccessLayer.SqlClient" connectionStringName="SqlServerConnectionString"providerInvariantName="System.Data.SqlClient"entityFactoryType="Juris.Entities.EntityFactory" enableMethodAuthorization="false"useEntityFactory="true" commandTimeout="30"/> >>> <add name="WsNetTiersProvider"type="Juris.DataAccessLayer.WebServiceClient.WsNetTiersProvider, Juris.DataAccessLayer.WebServiceClient"url="http://localhost/NetTiersWS/JurisDataAccessLayerWebServices.asmx"commandTimeout="100"/> >>> <add name="MirrorNetTiersProvider" useStoredProcedure="true"enableEntityTracking="true" type="Juris.DataAccessLayer.SqlClient.SqlNetTiersProvider, Juris.DataAccessLayer.SqlClient" connectionStringName="SqlServerConnectionString"providerInvariantName="System.Data.SqlClient"entityFactoryType="Juris.Entities.EntityFactory" enableMethodAuthorization="false"useEntityFactory="true"/> >>> </providers> >>> </netTiersService> >>> >>> The app.config for the unit test project contains this: >>> <configSections> >>> <section >>> name="cachingConfiguration"type="Microsoft.Practices.EnterpriseLibra >>> ry.Caching.Configuration.CacheManagerSettings, >>> Microsoft.Practices.EnterpriseLibrary.Caching, Version=2.0.0.0, >>> Culture=neutral, PublicKeyToken=null"/> <section >>> name="dataProviderFactory"type="Juris.DataAccessLayer.Factory.DataPr >>> oviderFactoryConfiguration, Juris.DataAccessLayer.Factory" >>> allowLocation="true" >>> allowDefinition="Everywhere"restartOnExternalChanges="true"/> >>> <section >>> name="netTiersService"type="Juris.DataAccessLayer.Bases.NetTiersServ >>> i >>> c eSection, >>> Juris.DataAccessLayer"allowDefinition="MachineToApplication" >>> restartOnExternalChanges="true"/> </configSections> >>> >>> <dataProviderFactory> >>> <providers> >>> <provider dataSource="local" accessMode="local" connectionType="disconnected"name="FirebirdNetTiersProvider"/> >>> <provider dataSource="remote" accessMode="direct" connectionType="directConnect"name="SqlNetTiersProvider"/> >>> <provider dataSource="remote" accessMode="web" >>> connectionType="webConnect"name="WsNetTiersProvider"/> >>> </providers> >>> </dataProviderFactory> >>> >>> <system.data> >>> <DbProviderFactories> >>> <add name="Firebird Data Provider" invariant="FirebirdSql.Data.FirebirdClient"description=".Net Framework Data Provider for Firebird"type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient"/> >>> </DbProviderFactories> >>> </system.data> >>> <netTiersService> >>> <providers> >>> <add name="FirebirdNetTiersProvider"type="Juris.DataAccessLayer.FirebirdClient.FirebirdNetTiersProvider, Juris.DataAccessLayer.FirebirdClient" useStoredProcedure="true"providerInvariantName="FirebirdSql.Data.FirebirdClient"providerName="FirebirdSql.Data.FirebirdClient"entityFactoryType="Juris.Entities.EntityFactory" enableEntityTracking="true"enableMethodAuthorization="false" useEntityFactory="true" pooling="false"/> >>> <add name="SqlNetTiersProvider" useStoredProcedure="true"enableEntityTracking="true" type="Juris.DataAccessLayer.SqlClient.SqlNetTiersProvider, Juris.DataAccessLayer.SqlClient" providerInvariantName="System.Data.SqlClient"entityFactoryType="Juris.Entities.EntityFactory" enableMethodAuthorization="false"/> >>> <add name="WsNetTiersProvider"type="Juris.DataAccessLayer.WebServiceClient.WsNetTiersProvider, Juris.DataAccessLayer.WebServiceClient"url="http://localhost/NetTiersWS/JurisDataAccessLayerWebServices.asmx"/> >>> </providers> >>> </netTiersService> >>> >>> What is it that I am missing? >>> >>> Thanks, >>> >>> Greg. >>> From: Hernán Martínez [mailto:her...@ob...] >>> Sent: Thursday, August 01, 2013 4:57 PM >>> To: For users and developers of the Firebird .NET providers >>> Cc: fir...@li... >>> Subject: Re: [Firebird-net-provider] Error finding .Net provider but >>> only in unit tests >>> >>> You want to add Firebird's entry also in the test project app.config file. >>> Include a remove before the add too. >>> >>> Hernán MF S >>> >>> El 01/08/2013, a las 22:08, "Bradburn, Greg (LNG-RDU)" <gre...@le...> escribió: >>> >>> Greetings, >>> >>> We are using Firebird 2.0.1 in embedded mode and everything works >>> fine in the application but whenever I try to run unit tests against Firebird I get either: >>> System.ArgumentException: Unable to find the requested .Net >>> Framework Data Provider. It may not be installed. at >>> System.Data.Common.DbProviderFactories.GetFactory(String >>> providerInvariantName) >>> >>> or >>> System.Configuration.ConfigurationErrorsException: Failed to find or >>> load the registered .Net Framework Data Provider. at >>> System.Data.Common.DbProviderFactories.GetFactory(DataRow >>> providerRow) >>> >>> The former if have an entry in machine.config for >>> FirebirdSql.Data.FirebirdClient and the latter if I remove it. >>> >>> I have spent days trying to diagnose this. I have verified that all >>> the required dlls and supporting files for Firebird embedded get copied to the TestResults\Out folder. >>> >>> I had this issue in VS 2010 and am still having the issue after >>> migrating my projects to VS 2012 and .Net 4.5. >>> >>> I tried upgrading Firebird to 2.5.2 and the Firebird Client to 3.0.2 >>> and had the exact same results. >>> >>> Thanks in advance for any help you can offer on this. >>> >>> Regards, >>> >>> Greg B. >>> >>> Regards, >>> Greg. >>> >>> Greg Bradburn >>> Sr. Software Engineer >>> LexisNexis - Business of Law Software Solutions >>> 2000 Regency Pkwy, Suite 600 >>> Cary, NC 27518 >>> 919-297-1788 Direct >>> >>> >>> -------------------------------------------------------------------- >>> - >>> - >>> -------- Get your SQL database under version control now! >>> Version control is standard for application code, but databases >>> havent caught up. So what steps can you take to put your SQL >>> databases under version control? Why should you start doing it? Read more to find out. >>> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg. >>> c lktrk _______________________________________________ >>> Firebird-net-provider mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider >>> -------------------------------------------------------------------- >>> - >>> - >>> -------- Get your SQL database under version control now! >>> Version control is standard for application code, but databases >>> havent caught up. So what steps can you take to put your SQL >>> databases under version control? Why should you start doing it? Read more to find out. >>> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg. >>> c lktrk_______________________________________________ >>> Firebird-net-provider mailing list >>> Fir...@li... >>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider >> >> >> --------------------------------------------------------------------- >> - >> -------- Get your SQL database under version control now! >> Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. >> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg. >> c lktrk _______________________________________________ >> Firebird-net-provider mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider >> >> --------------------------------------------------------------------- >> - >> -------- Get your SQL database under version control now! >> Version control is standard for application code, but databases >> havent caught up. So what steps can you take to put your SQL >> databases under version control? Why should you start doing it? Read more to find out. >> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg. >> c lktrk _______________________________________________ >> Firebird-net-provider mailing list >> Fir...@li... >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > ---------------------------------------------------------------------- > -------- Get your SQL database under version control now! > Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.c > lktrk _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ---------------------------------------------------------------------- > -------- Get your SQL database under version control now! > Version control is standard for application code, but databases havent > caught up. So what steps can you take to put your SQL databases under > version control? Why should you start doing it? Read more to find out. > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.c > lktrk _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
