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 originally posted about this issue back in September 2009 and because of other priorities put it to bed for a while.
http://tech.groups.yahoo.com/group/firebird-support/message/104705

I have since took it up again and 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.