firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] Connection Fails On Changing masterkey Password for Firebird-3.0.0.30566_0_Win32_Alpha1 With NETProvider-3.1.0.0

[Lt C. R. C. <rds...@ya...>]

Mark Rotteveel <mark@...> writes:



> 

> On 10-8-2013 03:54, LtColRDSChauhan wrote:

> > Hi,

> > 1.  Connection Fails On Changing masterkey Password for

> > Firebird-3.0.0.30566_0_Win32_Alpha1 with the error message :

> > "Your user name and password are not defined.  Ask you database

> > administrator to set up a Firebird login "

> > 2.  Firebird provider : NETProvider-3.1.0.0.

> > 3.  Windows 7 32 Bit.

> > 4.  The connection string as under :

> > <add name="conStrHIS"

> > 
connectionString="User=SYSDBA;Password=masterkey;Database=D:\HIS\SolutionHis
FBD\HISFireBird\HOSPITALINFORMATIONSYSTEM.FDB;DataSource=DBPC;Port=3050;Dial
ect=3;

> > Charset=NONE;Role=; Connection lifetime=15;

> > Pooling=true;MinPoolSize=5;MaxPoolSize=50;Packet

> > Size=8192;ServerType=Default;"

> > providerName="FirebirdSql.Data.FirebirdClient" />

> 

> As far as I know the .NET provider does not support the new 

> authentication mechanism yet. The windows installer enables legacy 

> authentication and sets up two SYSDBA users: one with a password for the 

> new authentication system, and one for the old authentication system.

> 

> However Firebird 3 alpha 1 only support one 'UserManager' at a time, and 

> it uses the user manager for the new authentication mechanism. So I 

> guess you changed the password for the SYSDBA in the new authentication 

> mechanism. You will probably find that you can still connect with the 

> old password.

> 

> To change the password for the old authentication mechanism, you need to 

> edit firebird.conf and add (or update) the line UserManager = 

> Legacy_UserManager.

> 

> You can then change the password with GSEC. For other ways of changing 

> the password you either need to restart Firebird, or do something with 

> gsec first.

> 

> Jaybird also doesn't implement the authentication mechanism yet. I 

> described this issue on the Jaybird wiki: 

> http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=tip:firebird30a1

> 

> Mark



Hi Mark,

1. Thanks for your response.  

2. Did the following :-

   (a) Added the line UserManager = Legacy_UserManager

   (b) Changed the password with GSEC



3. Now the login through .NET provider works for sysdba. But the Flamerobin 
continues to accept the password masterkey and rejects the newly set 
password. Please advise.

Regards,

RDSC

Re: [Firebird-net-provider] Connection Fails On Changing masterkey Password for Firebird-3.0.0.30566_0_Win32_Alpha1 With NETProvider-3.1.0.0

[Mark R. <ma...@la...>]

On 10-8-2013 03:54, LtColRDSChauhan wrote:
> Hi,
> 1.  Connection Fails On Changing masterkey Password for
> Firebird-3.0.0.30566_0_Win32_Alpha1 with the error message :
> "Your user name and password are not defined.  Ask you database
> administrator to set up a Firebird login "
> 2.  Firebird provider : NETProvider-3.1.0.0.
> 3.  Windows 7 32 Bit.
> 4.  The connection string as under :
> <add name="conStrHIS"
> connectionString="User=SYSDBA;Password=masterkey;Database=D:\HIS\SolutionHisFBD\HISFireBird\HOSPITALINFORMATIONSYSTEM.FDB;DataSource=DBPC;Port=3050;Dialect=3;
> Charset=NONE;Role=; Connection lifetime=15;
> Pooling=true;MinPoolSize=5;MaxPoolSize=50;Packet
> Size=8192;ServerType=Default;"
> providerName="FirebirdSql.Data.FirebirdClient" />

As far as I know the .NET provider does not support the new 
authentication mechanism yet. The windows installer enables legacy 
authentication and sets up two SYSDBA users: one with a password for the 
new authentication system, and one for the old authentication system.

However Firebird 3 alpha 1 only support one 'UserManager' at a time, and 
it uses the user manager for the new authentication mechanism. So I 
guess you changed the password for the SYSDBA in the new authentication 
mechanism. You will probably find that you can still connect with the 
old password.

To change the password for the old authentication mechanism, you need to 
edit firebird.conf and add (or update) the line UserManager = 
Legacy_UserManager.

You can then change the password with GSEC. For other ways of changing 
the password you either need to restart Firebird, or do something with 
gsec first.

Jaybird also doesn't implement the authentication mechanism yet. I 
described this issue on the Jaybird wiki: 
http://jaybirdwiki.firebirdsql.org/jaybird/doku.php?id=tip:firebird30a1

Mark
-- 
Mark Rotteveel

[Firebird-net-provider] Connection Fails On Changing masterkey Password for Firebird-3.0.0.30566_0_Win32_Alpha1 With NETProvider-3.1.0.0

[LtColRDSChauhan <rds...@gm...>]

Hi,

1.  Connection Fails On Changing masterkey Password for
Firebird-3.0.0.30566_0_Win32_Alpha1 with the error message :
"Your user name and password are not defined.  Ask you database
administrator to set up a Firebird login "

2.  Firebird provider : NETProvider-3.1.0.0.

3.  Windows 7 32 Bit.

4.  The connection string as under :

<add name="conStrHIS"
connectionString="User=SYSDBA;Password=masterkey;Database=D:\HIS\SolutionHisFBD\HISFireBird\HOSPITALINFORMATIONSYSTEM.FDB;DataSource=DBPC;Port=3050;Dialect=3;
Charset=NONE;Role=; Connection lifetime=15;
Pooling=true;MinPoolSize=5;MaxPoolSize=50;Packet
Size=8192;ServerType=Default;" providerName
="FirebirdSql.Data.FirebirdClient" />

Thanks & Regards,
Lt Col (Retd) Rajiv Dular Singh Chauhan

[Firebird-net-provider] [FB-Tracker] Created: (DNET-515) Boolean support

[Rand R. (JIRA) <tr...@fi...>]

Boolean support
---------------

                 Key: DNET-515
                 URL: http://tracker.firebirdsql.org/browse/DNET-515
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
    Affects Versions: 3.1.0.0
         Environment: Win7 x64 - VS 2012 - .NET Provider 3.1.0.0 - Firebird 3.0.0 alpha 1
            Reporter: Rand Random
            Assignee: Jiri Cincura


Hi.

Was trying to test the new boolean support, but couldnt create a new .EDMX file, everything seems to work with Firebird 3.0.0 but not the new boolean type.

Getting the following exception:
Unable to generate the model because of the following exception: 'The value for column 'DataType' in table 'TableDetails' is DBNull.
	Unable to cast object of type 'System.DBNull' to type 'System.String'.
'.
Loading metadata from the database took 00:00:00.4088832.
Generating the model took 00:00:00.2426821.
Unable to generate the model because of the following exception: 'The value for column 'DataType' in table 'TableDetails' is DBNull.
	Unable to cast object of type 'System.DBNull' to type 'System.String'.
'.
Loading metadata from the database took 00:00:00.3077974.
Generating the model took 00:00:00.1603336.
Added the connection string to the App.Config file.
Writing the .edmx file took 00:00:00.0013773.

Not sure if its a bug or just forgotten or not planned, though I kinda hoped since .NET Provider got update only few days before the Alpha 1 release that it has full support.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-514) SQL error code = -204

[Rand R. (JIRA) <tr...@fi...>]

SQL error code = -204
---------------------

                 Key: DNET-514
                 URL: http://tracker.firebirdsql.org/browse/DNET-514
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider, DDEX Provider, Entity Framework support
    Affects Versions: 3.1.0.0
         Environment: Win7 x64 - .NET 4.5 - VS 2012 - EF 5.0
            Reporter: Rand Random
            Assignee: Jiri Cincura


I installed the new .NET Provider and tried to update my EDMX Model (with Database First) but I am getting the following in my output window:

Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
	Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
		Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.4426206.
Generating the model took 00:00:07.6167923.
Added the connection string to the App.Config file.
Writing the .edmx file took 00:00:00.0012551.

I am creating the following Domain, since Firebird 2.5 and earlier is lacking support for boolean:

SET TRANSACTION;

SET TERM !! ;
EXECUTE BLOCK AS BEGIN

if (exists(select 1 from rdb$fields f, rdb$types t 
              where f.rdb$field_name='BOOLEAN' 
                  and f.rdb$field_type=t.rdb$type 
                  and t.rdb$field_name='RDB$FIELD_TYPE')) then
	execute statement 'drop DOMAIN BOOLEAN;';
    
  execute statement 'CREATE DOMAIN BOOLEAN
    	AS SMALLINT DEFAULT 0
    	CHECK (value in (0, 1));';
END!!
SET TERM ; !!


COMMIT TRANSACTION;

could this be the root of the problem, and how would I fix it?

In my Database I have 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests

[Hernan M. <her...@ob...>]

I'm sorry but don't have my dev machine at hand so I can't tell you about what's in our machine.config, only the source version control of our repository.
This is the .csproj:

    <Reference Include="FirebirdSql.Data.FirebirdClient">
      <HintPath>..\Externals\FirebirdSql.Data.FirebirdClient.dll</HintPath>
      <Private>True</Private>
    </Reference>

Under the Externals directory I've put the DLL (that and any other third party) so I don't depend on the local installation, a checkout, a compile and I'm running. I particularly avoid the FirebirdClient msi (not that I have anything against it) and just download the .zip and update the binary that we have under version control.




El 02/08/2013, a las 22:58, "Bradburn, Greg (LNG-RDU)" <gre...@le...> escribió:

> 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
> ------------------------------------------------------------------------------
> 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

Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests

[Bradburn, G. (LNG-RDU) <gre...@le...>]

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

Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests

[Hernan M. <her...@ob...>]

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.NetTiersServi
>>> 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.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.NetTiersServi
>>> 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.clktrk
> _______________________________________________
> 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

Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests

[Bradburn, G. (LNG-RDU) <gre...@le...>]

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.NetTiersServi
>> 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.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.NetTiersServi
>> 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.clktrk
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests

[Hernán M. <her...@ob...>]

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.NetTiersServic
>> 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.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.NetTiersServic
>> 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.clktrk
> _______________________________________________
> 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

Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests

[Bradburn, G. (LNG-RDU) <gre...@le...>]

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.NetTiersServic
> 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.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.NetTiersServic
> 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.clktrk
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests

[Hernan M. <her...@ob...>]

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.NetTiersServiceSection, 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.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.NetTiersServiceSection, 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.clktrk
> _______________________________________________
> 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

Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests

[Bradburn, G. (LNG-RDU) <gre...@le...>]

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.NetTiersServiceSection, 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.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.NetTiersServiceSection, 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...<mailto: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.clktrk
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...<mailto:Fir...@li...>
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Error finding .Net provider but only in unit tests

[Hernán M. <her...@ob...>]

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.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Error finding .Net provider but only in unit tests

[Bradburn, G. (LNG-RDU) <gre...@le...>]

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

[Firebird-net-provider] [FB-Tracker] Created: (DNET-513) "Implementation limit exceeded" after upgrading from 3.0.2.0 to 3.1.0.0

[NoPyGod (JIRA) <tr...@fi...>]

"Implementation limit exceeded" after upgrading from 3.0.2.0 to 3.1.0.0
-----------------------------------------------------------------------

                 Key: DNET-513
                 URL: http://tracker.firebirdsql.org/browse/DNET-513
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.1.0.0
         Environment: Windows 7 64bit
            Reporter: NoPyGod
            Assignee: Jiri Cincura
         Attachments: Databases.zip, Setting.cs

With version 3.0.2.0, the following LINQ query

var isMaster = configDb.Settings.Where(x => x.Key == @"\ALPHA\ENVIRONMENT\MASTER").Single().Value == "1";

Was translated into

SELECT FIRST (2) 
"B"."CONFIGKEY" AS "CONFIGKEY", 
"B"."CONFIGVALUE" AS "CONFIGVALUE"
FROM "CONFIGURATION" AS "B"
WHERE _UTF8'\ALPHA\ENVIRONMENT\MASTER' = "B"."CONFIGKEY"

This works fine. Have been using the ADO.NET provider for months without any trouble

But today I tried to upgrade to version 3.1.0.0 of the provider, and now that same linq query is being translated into the SQL below

SELECT FIRST (2) 
"B"."CONFIGKEY" AS "CONFIGKEY", 
"B"."CONFIGVALUE" AS "CONFIGVALUE"
FROM "CONFIGURATION" AS "B"
WHERE CAST(_UTF8'\ALPHA\ENVIRONMENT\MASTER' AS VARCHAR(32765)) = "B"."CONFIGKEY"

Notice it now CASTs to VARCHAR(32765)

This unfortunately is giving an error:

Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal

I tried executing the same sql query outside of .NET, from IBExpert, and it also gives the same error there.

I have tried so many different things in IBExpert to get this to work but to no avail. I discovered that if I export the table structure and create a new database and import the structure into a new table, I can run the query without problems. I thought this might mean there was a problem with the database so I did the usual gfix, backup restore but that hasn't helped.

I've attached a zip containing two databases, one which works and the one which doesn't. Please try running this query to see the error I'm referring to --

SELECT *
FROM CONFIGURATION
WHERE CONFIGKEY = CAST(_UTF8'TEST' AS VARCHAR(32765))

I don't know if this is a problem with the ADO.NET provider or with the Firebird engine itself, but since 3.0.2.0 worked and 3.1.0.0 doesn't I thought I'd report it here.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[Firebird-net-provider] [FB-Tracker] Created: (DNET-512) NETProvider-3.1.0.0.msi does not add entries into 64bit config

[NoPyGod (JIRA) <tr...@fi...>]

NETProvider-3.1.0.0.msi does not add entries into 64bit config
--------------------------------------------------------------

                 Key: DNET-512
                 URL: http://tracker.firebirdsql.org/browse/DNET-512
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 3.0.2.0
         Environment: Windows 7 64bit
            Reporter: NoPyGod
            Assignee: Jiri Cincura
            Priority: Minor


When you run the NETProvider-3.1.0.0.msi installer, it correctly adds the "FirebirdClient Data Provider" under the System.Data\DbProviderFactories secton of the machine.config

    C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config

    <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=3.0.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/></DbProviderFactories>
    </system.data>

But it does not add the same entry to the 64bit config

    C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config

So if I deploy my application to a 64bit machine I get the error

    "Unable to determine the provider name for connection of type 'FirebirdSql.Data.FirebirdClient.FbConnection'."

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Re: [Firebird-net-provider] Releasing more often???

[Jiri C. <di...@ci...>]

http://blog.cincura.net/233371-firebirds-ado-net-provider-sources-has-a-new-home/
and http://blog.cincura.net/233379-ado-net-provider-for-firebird-3-1-0-0-is-ready/
. First steps.


-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Improving

[Jiri C. <di...@ci...>]

http://blog.cincura.net/233371-firebirds-ado-net-provider-sources-has-a-new-home/

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

[Firebird-net-provider] ADO.NET provider for Firebird 3.1.0.0

[Jiri C. <di...@ci...>]

Hi *,

The version 3.1.0.0 of ADO.NET provider for Firebird is ready for your download!

More info: http://blog.cincura.net/233379-ado-net-provider-for-firebird-3-1-0-0-is-ready/
.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] .NET provider Visual Studio 2010 solution

[Begench A. <ba...@gm...>]

Ok. I will try with Visual Studio 2012 Express.

2013/7/26, Mark Rotteveel <ma...@la...>:
> On Fri, 26 Jul 2013 05:40:12 +0500, Begench Amanov <ba...@gm...>
> wrote:
>> Sorry for inconvenience, but I don't know where else I can ask this
>> question.
>> I don't have acces to Visual Studio 2012 (I have Visual Studio 2010) and
> I
>> downloaded Firebird .NET 3.0.2.0 provider source from firebird website
> and
>> my Visual studio 2010 can't open this solution. Can I build it with
>> SharpDevelop? Or can you upload Visual Studio 2010 solution to firebird
>> website?
>
> You can use Visual Studio 2012 Express for Windows Desktop.
>
> Mark
>
> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] .NET provider Visual Studio 2010 solution

[Mark R. <ma...@la...>]

On Fri, 26 Jul 2013 05:40:12 +0500, Begench Amanov <ba...@gm...>
wrote:
> Sorry for inconvenience, but I don't know where else I can ask this
> question.
> I don't have acces to Visual Studio 2012 (I have Visual Studio 2010) and
I
> downloaded Firebird .NET 3.0.2.0 provider source from firebird website
and
> my Visual studio 2010 can't open this solution. Can I build it with
> SharpDevelop? Or can you upload Visual Studio 2010 solution to firebird
> website?

You can use Visual Studio 2012 Express for Windows Desktop.

Mark

[Firebird-net-provider] .NET provider Visual Studio 2010 solution

[Begench A. <ba...@gm...>]

Sorry for inconvenience, but I don't know where else I can ask this
question.
I don't have acces to Visual Studio 2012 (I have Visual Studio 2010) and I
downloaded Firebird .NET 3.0.2.0 provider source from firebird website and
my Visual studio 2010 can't open this solution. Can I build it with
SharpDevelop? Or can you upload Visual Studio 2010 solution to firebird
website?
Because when I build it with SharpDevelop it gives me 11 warnings but no
errors.

1) FbProviderServices - processor architecture mismatch
2) Type of ... is not CLS compliant.

I'm asking because I use this provider with NHibernate, and can't find any
wait to set NO WAIT transactions or WAIT transaction timeout through
NHibernate. So I thought to add IsNoWait and WaitTimeout publict static
fields to FbTransaction to use in BuildTpb() methods.

Will be very grateful is you can answer me to give some pointers.

Re: [Firebird-net-provider] [FB-Tracker] Created: (DNET-511) Firebird ADO.NET Data Provider Version 3.0.2 does not support .Net Framework 4?

[William J. <bi...@te...>]

You may indeed need an assembly reference added, but .NET 4.0 has its own provider installation related issues.

Here are notes that have worked for me with visual studio 2010 using .net 4.0 on a 64 bit Windows 7 and XP.

Visual Studio 2010 does NOT support development with .NET 4.5 but use the full .NET 4.0, not the client 4.0 in your project properties.

Install:  NETProvider-3.0.2.0.msi

The client MSI install has a problem with a bug in .NET 4.0. So, you need to replace the dll installed with a .NET4.0 version.
Copy both files from NETProvider-3.0.2.0-NET40.7z over the installed ones at "C:\Program Files (x86)\FirebirdClient".
For XP, adjust install path "C:\Program Files\FirebirdClient".

Then, copy the dll file over top of the GAC copy at "C:\Windows\Microsoft.NET\assembly\GAC_MSIL\FirebirdSql.Data.FirebirdClient\v4.0_3.0.2.0__3750abcc3150b00c".

Install: DDEXProvider-3.0.0.0.msi, use advanced option to add visual studio 2010 components.

Install  DDEXProvider-3.0.0.0-src\reg_files\VS2010\ FirebirdDDEXProvider64.reg to fix msi missing stuff.
(For XP, install DDEXProvider-3.0.0.0-src\reg_files\VS2010\FirebirdDDEXProvider32.reg)

Components in the toolbox still don't operate as I expected but the dialogs for data sources and entity framework tools seem to work.

Be sure to use a database alias to avoid issues with windows pathname characters.

Hope that helps,

+BillJ

Re: [Firebird-net-provider] Windows Phone 8

[André K. <Kna...@be...>]

Okay, thanks.
Means I am not even starting to deal with using VS to create WP8 apps.

I'll  continue like before; employees using a VPN to a Terminal server
to work with our data in some places, Webservices in other places.

As soon as MS provides VPN for WP8

> I think the root is even deeper. WP does not contain ADO.NET stack at
> all. You're not expected to connect to local database, rather use some
> "data service" and connect via network (which makes sense today). Yes,
> of course, you can always do your own ADO.NET clone and run some
> database of your own. But you'd have to deal with tombstoning, suspend
> states, ... to make it ACID. To just cache/store data locally you can
> use Isolated Storage.

> And of course, the Firebird itself doesn't run on WP - partly because
> MS doesn't allow you native code and partly because it was not
> compiled for this platform.


> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com

> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider



mit freundlichen Grüßen,

André Knappstein
EDV und Controlling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH
Hafenweg 4
59192 Bergkamen-Rünthe

Telefon: +49 2389 9240 140
Telefax: +49 2389 9240 150
e-mail:  kna...@be...

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402