1

I've installed the latest Firebird ADO.Net Provider (FirebirdSql.Data.FirebirdClient-4.5.1.0.msi) and the latest Firebird DDEX Provider (DDEXProvider-3.0.1.0.msi).

Both providers are registered in GAC.

FirebirdSql.VisualStudio.DataTools, Version=3.0.1.0, Culture=neutral, PublicKeyToken=bae6c78ccb0fcdb3, processorArchitecture=MSIL

FirebirdSql.Data.FirebirdClient, Version=4.5.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL

The Firebird ADO.Net Provider is also registered in the "DbProviderFactories" Node of the machine.config (for both x86 and x64). 

<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=4.5.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>

I'm trying to create a new Database Connection using the DDEX Provider in VS2013 SP3, but it's not working. When I change any values in the "Firebird Data Source" connection dialog, the dialog disappears.

I debugged VS2013 in background with a 2nd VS2013 Instance and got this Output messages, while the connection dialog disappears:

FbDataConnectionUIControl::LoadProperties()
Eine Ausnahme (erste Chance) des Typs "System.NullReferenceException" ist in FirebirdSql.VisualStudio.DataTools.dll aufgetreten.

System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei FirebirdSql.VisualStudio.DataTools.FbDataConnectionUIControl.LoadProperties()
FbDataConnectionUIControl::LoadProperties()

Eine Ausnahme (erste Chance) des Typs "System.NullReferenceException" ist in FirebirdSql.VisualStudio.DataTools.dll aufgetreten.

System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
   bei FirebirdSql.VisualStudio.DataTools.FbDataConnectionUIControl.LoadProperties()

Eine Ausnahme (erste Chance) des Typs "System.NullReferenceException" ist in FirebirdSql.VisualStudio.DataTools.dll aufgetreten.

Any ideas how I can get the provider to run or where I can look for other prerequisites?

Jens
  • 21
  • 3
  • I'd suggest you file a bug report on http://tracker.firebirdsql.org/browse/DNET – Mark Rotteveel Oct 15 '14 at 08:36
  • I've just created a [bug report on tracker.firebirdsql.org](http://tracker.firebirdsql.org/browse/DNET-571). The link should work soon. – Jens Oct 15 '14 at 11:03
  • They've deleted my bug report immediately from the bug-tracker, with the comment "This is not a forum". :o( Seems that there's no support from the persons they know what happens inside DDEX.. – Jens Oct 15 '14 at 11:18
  • Weird, I'd classify this as a bug, if not in the library itself, then in the documentation... – Mark Rotteveel Oct 15 '14 at 13:00
  • 1
    I think it's a Setup Bug. Additionaly the UI should check the drivers and settings and should show a related message instead of killing the dialog window. – Jens Oct 15 '14 at 13:19
  • make sure the FB provider is registered in the machine.config – magicandre1981 Oct 15 '14 at 16:00
  • It is registered in the machine.config files (x86 and x64). See above – Jens Oct 16 '14 at 16:46

2 Answers2

1

I had a similar problem and after a week of googling I think I have found a fix.

Download and install the following:

  1. Visual Studio SDK
  2. Firebird ADO.NET Data Provider
  3. Firebird DDEX Provider

When installing the providers, make sure to click on the "Advanced" button. This is needed for installing the DDEX provider as it will give you a chance to choose which versions of Visual Studio it will get installed on. Installation on the GAC and registry should be taken care of by the DDEX installer.

HTH.

Victor Ian
  • 1,034
  • 13
  • 26
0

I had a similar problem. I removed the FirebirdSql.Data.FirebirdClient.dll from the GAC, uninstalled and reinstalled DDEX and registered the firebird client in C:\Program Files (x86)\FirebirdClient\FirebirdSql.Data.FirebirdClient.dll (which i downloaded as an msi installer from firebirdsql.org

Not sure if this will fix your problem but worth a try.

Beach
  • 93
  • 5